| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete all dulplicate rows leaving no record of the duplicates | Excel Discussion (Misc queries) | |||
| Find duplicates, sum column then delete duplicates | Excel Programming | |||
| Compare Rows - any unique into new sheet / delete duplicates | Excel Programming | |||
| find duplicates between rows, keep or delete entries based on ranked relevance | Excel Programming | |||
| delete duplicates macro to color instead of delete | Excel Programming | |||
Linear Mode
