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) |