find last row in group

[Danny54]

Good Morning

how would I go about achieving the following

my data looks like this

a	car
a	boat
a	motorcycle
b	boat
b	car
c	house

the desired output - Put a x in column "C" marking this to be the last row listed for each group of column "A"

a	car
a	boat
a	motorcycle	x
b	boat
b	car	x
c	house	x

Can be a formula or a macro

Thanks

 

[Joe4]

Put this formula on row 1 and copy down for all rows:

=IF(A1<>A2,"x","")

 

[Danny54]

Perfect.

Thanks so much

 

[Joe4]

You are welcome.
Glad I was able to help!