Another question on how to find duplicate data
 

I went to a website that I was directed to find duplicate data. It did show
me how to find duped data but it did not help me. I was able to get it to
work on simple data. I am trying to do a search on 5 columns and 200 rows of
data that contains serial numbers on hard drives. Is this possible to do? If
I remember right the website was www.cpearson.com. Thanks in advance for
the help.

Eric

Let's say your data looks something like:

Jane Doe 123 Whereever
Jerry Doe 123 Whatever
Jane Smith 123 Whoever

And you want to find the duplicates with Doe and 123 in them. The easy way
is to create a new column that combines the columns you are testing. So the
5th column would be:

Doe123
Doe123
Smith123

Then write either use the Subtotals feature (Data menu) or write a COUNTIF
formula in the 6th column (=COUNTIF($E$1:$E$3,E1)).

"Eroc" wrote:

I went to a website that I was directed to find duplicate data. It did show
me how to find duped data but it did not help me. I was able to get it to
work on simple data. I am trying to do a search on 5 columns and 200 rows of
data that contains serial numbers on hard drives. Is this possible to do? If
I remember right the website was www.cpearson.com. Thanks in advance for
the help.

Eric

Hi!

Please explain exactly what you mean when you say "it did
not help me. I was able to get it to work on simple data."

What exactly do you want to find?

The quality of the solution you seek is related to the
detail of the description that you provide.

Biff

-----Original Message-----
I went to a website that I was directed to find duplicate
data. It did show
me how to find duped data but it did not help me. I was
able to get it to
work on simple data. I am trying to do a search on 5
columns and 200 rows of
data that contains serial numbers on hard drives. Is this
possible to do? If
I remember right the website was www.cpearson.com.
Thanks in advance for
the help.

Eric


.