Deleting duplicate records

K

Keensie

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?
 
M

mrice

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
 
Top