Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SPENCER
 
Posts: n/a
Default Help to find duplicate #'s


Hi Can someone please help me. I am using Excel 2002 and I have about
3,000 #'s (example 4992-5) that I want to find out if any of them are
duplicates. What function would I perform to solve my problem? I
appreciate any help you could offer.

Many thanks,

Spencer


--
SPENCER
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You may want to read some of Chip Pearson's techniques for dealing with
duplicates:
http://www.cpearson.com/excel/duplicat.htm

SPENCER wrote:

Hi Can someone please help me. I am using Excel 2002 and I have about
3,000 #'s (example 4992-5) that I want to find out if any of them are
duplicates. What function would I perform to solve my problem? I
appreciate any help you could offer.

Many thanks,

Spencer

--
SPENCER


--

Dave Peterson
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
Find duplicate rows then deleting them SSHO_99 Excel Worksheet Functions 4 May 4th 07 11:17 AM
2 workbooks - how do I find duplicate entries by comparing the two queen on Excel Discussion (Misc queries) 2 September 20th 05 11:12 AM
How do I find duplicate rows in a list in Excel, and not delete it Matthew in FL Excel Discussion (Misc queries) 2 June 15th 05 09:11 PM
How do you find duplicate values in excel- 2 columns of numbers rickmanz Excel Discussion (Misc queries) 1 December 15th 04 11:16 PM
Another question on how to find duplicate data Eroc Excel Worksheet Functions 2 December 14th 04 05:03 AM


All times are GMT +1. The time now is 08:34 PM.

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

About Us

"It's about Microsoft Excel"