Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Norman H
 
Posts: n/a
Default 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   Report Post  
patrick
 
Posts: n/a
Default

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   Report Post  
patrick
 
Posts: n/a
Default

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   Report Post  
RagDyeR
 
Posts: n/a
Default

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   Report Post  
PC
 
Posts: n/a
Default

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   Report Post  
Pat Flynn
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search one column and return value from next column shwekhaw Excel Discussion (Misc queries) 2 May 3rd 05 09:52 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
search a row to find the column Stephen Excel Worksheet Functions 2 March 23rd 05 01:51 AM
Excel search results are hard to identify. Monique Excel Worksheet Functions 2 March 18th 05 12:57 AM
Search column and move text formula tommy Excel Discussion (Misc queries) 0 February 8th 05 06:55 PM


All times are GMT +1. The time now is 05:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"