Home |
Search |
Today's Posts |
#1
|
|||
|
|||
search to identify duplicate enties in long columns of numbers
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 |
#2
|
|||
|
|||
http://www.cpearson.com/excel/topic.htm
Chuck Pearson has several methods at the above address under "Duplicate" Pat F "Norman H" wrote: 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 |
#3
|
|||
|
|||
sorry about that-was speaking to a Chuck on the phone and transposed!
"PC" wrote: Chip has a brother? "patrick" wrote in message ... http://www.cpearson.com/excel/topic.htm Chuck Pearson has several methods at the above address under "Duplicate" Pat F "Norman H" wrote: 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 |
#4
|
|||
|
|||
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 -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "patrick" wrote in message ... sorry about that-was speaking to a Chuck on the phone and transposed! "PC" wrote: Chip has a brother? "patrick" wrote in message ... http://www.cpearson.com/excel/topic.htm Chuck Pearson has several methods at the above address under "Duplicate" Pat F "Norman H" wrote: 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 |
#5
|
|||
|
|||
Chip has a brother?
"patrick" wrote in message ... http://www.cpearson.com/excel/topic.htm Chuck Pearson has several methods at the above address under "Duplicate" Pat F "Norman H" wrote: 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 |
#6
|
|||
|
|||
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 "RagDyeR" wrote: 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 -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "patrick" wrote in message ... sorry about that-was speaking to a Chuck on the phone and transposed! "PC" wrote: Chip has a brother? "patrick" wrote in message ... http://www.cpearson.com/excel/topic.htm Chuck Pearson has several methods at the above address under "Duplicate" Pat F "Norman H" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search one column and return value from next column | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
search a row to find the column | Excel Worksheet Functions | |||
Excel search results are hard to identify. | Excel Worksheet Functions | |||
Search column and move text formula | Excel Discussion (Misc queries) |