search to identify duplicate enties in long columns of numbers

[Guest]

Is there a quick and easy way to find/search/identify duplicate enteries in
any single coulmn within a worksheet that has multiple columes of 2 to 3000
Numbers in each column

 

[Guest]

http://www.cpearson.com/excel/topic.htm
Chuck Pearson has several methods at the above address under "Duplicate"
Pat F

 

[Guest]

sorry about that-was speaking to a Chuck on the phone and transposed!

 

[RagDyeR]

Actually Pat, you *are* technically correct, since Chip's first name is
really Charles, and Chuck is, I believe an accepted nick-name, ALTHOUGH ...
perhaps *not* acceptable to Chip.<g>

 

[PC]

Chip has a brother?

http://www.cpearson.com/excel/topic.htm
Chuck Pearson has several methods at the above address under "Duplicate"
Pat F

 

[Guest]

You are correct that Chuck is an accepted "American" nickname or deriviative
of Charles as is Charlie, although I don't believe that anyone refers to
"Prince Charles" and Charlie or Chuck. In this case my faux pax may have
inadvertently struck the bulls eye. Thanks for the FYI.
Best
Pat