Delete rows that contain duplicates
 

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

Delete rows that contain duplicates
 

On Mon, 15 Jul 2013 03:20:24 -0700 (PDT), Ange2011 wrote:

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