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