delete duplicate rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
How to delete all duplicate records - without keeping one of them 5
Best solution to merge multiple Outlook contacts easily 2
Spreadsheet - Deleting Duplicate Records - Self Checking 1
remove duplicate rows but keeping all columns 3
Deleting duplicates in Excel 4
Locate duplicates in column A, then, delete the row 3
using duplicate function 13

Back
Top