Display duplicate records?

  • Thread starter Thread starter Diane K
  • Start date Start date
D

Diane K

I have a list of over 13000 of my customer names. Many of the customers have
the same name, but are at a different address. I need to identify those with
a duplicate name. I don't want to delete them, I just want to highlight or
otherwise identify them. Any ideas?
 
You can sort the data by name, so that all identical names come
together. Then it is quite easy to introduce a formula like:

=IF(OR(A2=A1,A2=A3,"Duplicate","Unique")

in a helper column in row 2, and then copy this down the column (this
assumes that names are in column A). You can then fix the values, so
the description is then tagged with the name.

If the original order of the data is important to you, then you can
put a simple sequence 1,2,3 etc down another helper column first, and
then you will be able to re-sort the data back into that order once
you have done the above.

Hope this helps.

Pete
 
Sorry, missed a bracket in the formula:

=IF(OR(A2=A1,A2=A3),"Duplicate","Unique")

Apologies.

Pete
 
Thanks Pete and Dave. That's exactly what I needed!

--
Diane

Sorry, missed a bracket in the formula:

=IF(OR(A2=A1,A2=A3),"Duplicate","Unique")

Apologies.

Pete
 
Dear Diane,

You can easily extract duplicate records using Filord utility. All you need to do is to save your list as an Excel sheet, install the program and run Duplicates function. Find the details at www.filord.com




Diane K wrote:

Display duplicate records?
13-Feb-08

I have a list of over 13000 of my customer names. Many of the customers have
the same name, but are at a different address. I need to identify those with
a duplicate name. I don't want to delete them, I just want to highlight or
otherwise identify them. Any ideas

--
Thanks
Diane

Previous Posts In This Thread:

Display duplicate records?
I have a list of over 13000 of my customer names. Many of the customers have
the same name, but are at a different address. I need to identify those with
a duplicate name. I don't want to delete them, I just want to highlight or
otherwise identify them. Any ideas

--
Thanks
Diane

Re: Display duplicate records?
Chip Pearson has lots of techniques to work with duplicates
http://www.cpearson.com/excel/Duplicates.asp

Diane K wrote

-

Dave Peterson

Thanks Pete and Dave. That's exactly what I needed!
Thanks Pete and Dave. That's exactly what I needed

-
Dian

Sorry, missed a bracket in the formula

=IF(OR(A2=A1,A2=A3),"Duplicate","Unique"

Apologies

Pete

You can sort the data by name, so that all identical names cometogether.
You can sort the data by name, so that all identical names com
together. Then it is quite easy to introduce a formula like

=3DIF(OR(A2=3DA1,A2=3DA3,"Duplicate","Unique"

in a helper column in row 2, and then copy this down the column (thi
assumes that names are in column A). You can then fix the values, s
the description is then tagged with the name

If the original order of the data is important to you, then you ca
put a simple sequence 1,2,3 etc down another helper column first, an
then you will be able to re-sort the data back into that order onc
you have done the above

Hope this helps

Pet

v
th

Sorry, missed a bracket in the
Sorry, missed a bracket in the formula

=3DIF(OR(A2=3DA1,A2=3DA3),"Duplicate","Unique"

Apologies

Pet

hav
wit
or

Glad to be of help, Diane - thanks for feeding back.
Glad to be of help, Diane - thanks for feeding back

Pet



t

EggHeadCafe - Software Developer Portal of Choice
Host Winforms App in IE from your web server
http://www.eggheadcafe.com/tutorial...b-78bbd653d184/host-winforms-app-in-ie-f.aspx
 
Please refrain from spamming the newsgroups by answering a question that

1. Has already been answered

2. That is over 18 months old.


Then finally the spamming by posting a link to a commercial program.

--


Regards,


Peo Sjoblom
 
Back
Top