Duplicate Records

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi,
I have a list of customers in Excel about 2,500 long. I
want to delete duplicate records. My list is very simple.
A is their name. B is their street. C is town, etc...

I figure this has to be easy but I don't know how to do
it... :-(
 
Apply the advanced filter (data>filter>advanced filter)
copy to another location and select unique records only

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Here is a good resource;

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


Simply though, you can use a formula like this, in D, to check for duplicate
names in column A. This will put an "X" next to the first occurence. You can
then sort the range by column D (with out without X), and delete those
without the X if you're comfortable there aren't people with the same name
at 2 different addresses.

=IF(COUNTIF(A$1:A1,A1)>1,"","X")

in D, then copy it down the 2500 rows to cover all.
 
Peo,
I saw your reply to the same question back in January on
MCSE.MS. Anyway, I get an error, about select more than
one row (or something). I am selecting more than one row
of my data and my destination (another sheet in the same
workbook). What am I doing wrong?
 
Back
Top