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

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

Diane K wrote:
>
> 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

--

Dave Peterson

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

On Feb 13, 5:54*pm, "Diane K" <dkoers_nosp...@comcast.net> wrote:
> 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

Sorry, missed a bracket in the formula:

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

Apologies.

Pete

On Feb 13, 7:04*pm, Pete_UK <pashu...@auditel.net> wrote:
> 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
>
> On Feb 13, 5:54*pm, "Diane K" <dkoers_nosp...@comcast.net> wrote:
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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

--
Diane

"Pete_UK" <(E-Mail Removed)> wrote in message
news:6aaa5f98-2bf1-4143-8799-(E-Mail Removed)...
Sorry, missed a bracket in the formula:

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

Apologies.

Pete

On Feb 13, 7:04 pm, Pete_UK <pashu...@auditel.net> wrote:
> 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
>
> On Feb 13, 5:54 pm, "Diane K" <dkoers_nosp...@comcast.net> wrote:
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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

Pete

On Feb 13, 8:46*pm, "Diane K" <dkoers_nosp...@comcast.net> wrote:
> Thanks Pete and Dave. That's exactly what I needed!
>
> --
> Diane
>
> "Pete_UK" <pashu...@auditel.net> wrote in message
>
> news:6aaa5f98-2bf1-4143-8799-(E-Mail Removed)...
> Sorry, missed a bracket in the formula:
>
> =IF(OR(A2=A1,A2=A3),"Duplicate","Unique")
>
> Apologies.
>
> Pete
>
> On Feb 13, 7:04 pm, Pete_UK <pashu...@auditel.net> wrote:
>
>
>
> > 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
>
> > On Feb 13, 5:54 pm, "Diane K" <dkoers_nosp...@comcast.net> wrote:
>
> > > 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- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

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:

On Wednesday, February 13, 2008 12:54 PM
Diane K wrote:

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

On Wednesday, February 13, 2008 1:57 PM
Dave Peterson wrote:

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

On Wednesday, February 13, 2008 3:46 PM
Diane K wrote:

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

On Friday, February 15, 2008 2:38 AM
Pete_UK wrote:

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

On Feb 13, 5:54=A0pm, "Diane K" <dkoers_nosp...@comcast.net> wrote
v
th

On Friday, February 15, 2008 2:38 AM
Pete_UK wrote:

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

On Friday, February 15, 2008 2:39 AM
Pete_UK wrote:

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/tutorials...p-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


<Julia Vasuta> wrote in message news:(E-Mail Removed)...
> 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:
>
> On Wednesday, February 13, 2008 12:54 PM
> Diane K wrote:
>
> 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
>
> On Wednesday, February 13, 2008 1:57 PM
> Dave Peterson wrote:
>
> Re: Display duplicate records?
> Chip Pearson has lots of techniques to work with duplicates:
> http://www.cpearson.com/excel/Duplicates.aspx
>
> Diane K wrote:
>
> --
>
> Dave Peterson
>
> On Wednesday, February 13, 2008 3:46 PM
> Diane K wrote:
>
> Thanks Pete and Dave. That's exactly what I needed!
> 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
>
> On Friday, February 15, 2008 2:38 AM
> Pete_UK wrote:
>
> 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 come
> 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 (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
>
> On Feb 13, 5:54=A0pm, "Diane K" <dkoers_nosp...@comcast.net> wrote:
> ve
> th
>
> On Friday, February 15, 2008 2:38 AM
> Pete_UK wrote:
>
> Sorry, missed a bracket in the
> Sorry, missed a bracket in the formula:
>
> =3DIF(OR(A2=3DA1,A2=3DA3),"Duplicate","Unique")
>
> Apologies.
>
> Pete
>
> have
> with
> or
>
> On Friday, February 15, 2008 2:39 AM
> Pete_UK wrote:
>
> Glad to be of help, Diane - thanks for feeding back.
> Glad to be of help, Diane - thanks for feeding back.
>
> Pete
>
> s
> e
> t
>
> EggHeadCafe - Software Developer Portal of Choice
> Host Winforms App in IE from your web server
> http://www.eggheadcafe.com/tutorials...p-in-ie-f.aspx

Free ASAP Utilities has functions for this under "information"

"Julia Vasuta" wrote in message news:(E-Mail Removed)...
> 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:
>
> On Wednesday, February 13, 2008 12:54 PM
> Diane K wrote:
>
> 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
>
> On Wednesday, February 13, 2008 1:57 PM
> Dave Peterson wrote:
>
> Re: Display duplicate records?
> Chip Pearson has lots of techniques to work with duplicates:
> http://www.cpearson.com/excel/Duplicates.aspx
>
> Diane K wrote:
>
> --
>
> Dave Peterson
>
> On Wednesday, February 13, 2008 3:46 PM
> Diane K wrote:
>
> Thanks Pete and Dave. That's exactly what I needed!
> 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
>
> On Friday, February 15, 2008 2:38 AM
> Pete_UK wrote:
>
> 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 come
> 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 (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
>
> On Feb 13, 5:54=A0pm, "Diane K" <dkoers_nosp...@comcast.net> wrote:
> ve
> th
>
> On Friday, February 15, 2008 2:38 AM
> Pete_UK wrote:
>
> Sorry, missed a bracket in the
> Sorry, missed a bracket in the formula:
>
> =3DIF(OR(A2=3DA1,A2=3DA3),"Duplicate","Unique")
>
> Apologies.
>
> Pete
>
> have
> with
> or
>
> On Friday, February 15, 2008 2:39 AM
> Pete_UK wrote:
>
> Glad to be of help, Diane - thanks for feeding back.
> Glad to be of help, Diane - thanks for feeding back.
>
> Pete
>
> s
> e
> t
>
> EggHeadCafe - Software Developer Portal of Choice
> Host Winforms App in IE from your web server
> http://www.eggheadcafe.com/tutorials...p-in-ie-f.aspx