Deleting duplicate records
 

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?

Deleting duplicate records
 

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 your
data.

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

Another way is to sort the data by column A and use the EXACT function
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.


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=535055