Deleting duplicate records

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

Guest

I have a worksheet with over twelve thousand records, however there are
several duplicate records in this worksheet. Is there anyway I could quickly
locate these duplicate records and delete them?
 
There are several ways to do this.

Assuming that your data is in column A....

Type the following formula into B1

=COUNTIF(A:A,A1)

and copy this down to the other cells in column B adjacent to you
data.

If a value is replicated, the number returned by the formula will b
greater than 1. Using autofilters will allow you to quickly identif
the rows which appear multiple times.

Another way is to sort the data by column A and use the EXACT functio
to test if two adjacent rows are identical.

Type =EXACT(A1,A2) into B1

You will get a value of TRUE if adjacent rows are identical
 

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

remove duplicates but retain one not delete both 4
Identifying new records 2
Deleting duplicate records 2
remove all duplicate records 1
Quick way to elimate BOTH identical records? 1
delete all dulplicate rows leaving no record of the duplicates 3
create a separate list for unique records 3
How do I remove all records of duplicated fields? 3

Back
Top