View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default 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