Delete rows that contain duplicates

A

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
 
R

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
Click to expand...

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