| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete duplicate rows
I have a list of ID numbers and I want to see the duplicates and delete all
the other records. I have tried the Advanced Filter and it does not filter the list... I know that it can't be too difficult to filter out. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
delete duplicate rows
Assuming ID numbers in Column A, and header in row 1. Create a helper column
in B In B2: =COUNTIF($A$2:A2,A2)1 AutoFilter all the TRUE, select all the filter rows, go to menu select Edit, Delete Row, then delete the Helper column "christinaLO" wrote: I have a list of ID numbers and I want to see the duplicates and delete all the other records. I have tried the Advanced Filter and it does not filter the list... I know that it can't be too difficult to filter out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows with duplicate values | Excel Worksheet Functions | |||
| How do I delete both duplicate rows from a spreadsheet? | Excel Discussion (Misc queries) | |||
| Is there a quick way to delete all duplicate rows in a column? | Excel Discussion (Misc queries) | |||
| How do I delete duplicate rows in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
| How to delete duplicate rows in Excel 2000? | Excel Discussion (Misc queries) | |||
Linear Mode
