Delete rows that contain duplicates

[Ange2011]

Hi All,

Not sure if what I want to do is even possible, but thought I would give it a try.

I have a spreadsheet with names and I want to delete a row if it contains a duplicate name, is there any formula that can do this type of thing?

Thanks

 

[Ron Rosenfeld]

Hi All,

Not sure if what I want to do is even possible, but thought I would give it a try.

I have a spreadsheet with names and I want to delete a row if it contains a duplicate name, is there any formula that can do this type of thing?

Thanks

Look at the "Remove Duplicates" item on the Data ribbon