Find duplicates

[Ben]

I have two columns that I need to find the duplicates so I can delete them.

I don't mind doing it in two bites, to do one field first then the second.

Is there a formula I can do this with easily?

I have 8,000 records and probably 6,000 are duplicates!

Many thanks in anticipation, as I could find nothing in the HELP file.

--

 

[J.E. McGimpsey]

Take a look here:


http://www.cpearson.com/excel/duplicat.htm

and see Deleting Duplicate Rows:

http://www.cpearson.com/excel/deleting.htm

 

[Walda]

Rather than deleting duplicate records, rather identify the unique
records by doing this:

If you want to isolate the column and get all the unique records only
there, copy the entire column to a new sheet or workbook or somewhere
on it's own. Highlight the column, click on "Data" -> "Filter" ->
"Advanced Filter", make sure the "Unique Records Only" box is ticked
and click OK. Copy the list back to your original location and voila!
If you need to delete all the subsequent columns on either side of
the deleted duplicate record, just do the above filter with the entire
worksheet instead of the column, but applying the filter to the column
that you need to get sorted out. Then you can copy and paste the
entire worksheet onto a new sheet so it will only have the unique
records in there.