Macro to delete only certain rows

[uncleslinky]

Hi there

I have a list of accounts in column a and a value in column b.
the account in column can appear once or multiple times. I am trying to create a macro to keep only the LAST row of each account.

I've attached a sheet to explain in more detail

Any help would be great!
Thanks

[arthurbr]

Do you need a macro ? If not enter =IF(A2<>A3,A2,"") in D2 and pull down as needed

[uncleslinky]

Thanks for that!
I'll try to record it as a macro and filter the blanks and remove

Thanks again