ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   search to identify duplicate enties in long columns of numbers (https://www.excelbanter.com/excel-discussion-misc-queries/26839-search-identify-duplicate-enties-long-columns-numbers.html)

Norman H

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

patrick

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


patrick

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





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
--

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







PC

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




Pat Flynn

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









All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com