If cell in col B contains the same content as the cell above eg. B3=B2 then delete

[Steve_123]

Hi there

I have a set of data with a lot of duplicates. At the moment I'm adding a column and doing =IF(B3=B2,"Duplicate",""), copy and paste values then sorting and deleting all the Duplicates.

I'd like to do something in VBA that does this automatically and cleanly but am at a bit of a loss as to how that might happen.

It may well be the case that there are multiple duplicates eg. B2 is the same as B3, B4 and B5.

B2 should always be the row that remains with the others deleted.

I've attached some sample data.

Hope all is clear and thanks in advance for your help.

Steve

[alansidman]

On the ribbon under the Data tab, there is a built in function Remove Duplicates. Follow the wizard to remove duplicate entries.

[martindwilson]

why not use the remove duplicates option in the data tab?

[Steve_123]

For no reason other than my ignorance and incompetence martin!

Thanks both for your responses, wish I'd known about that some time ago!