PC Review


Reply
Thread Tools Rate Thread

Determining Duplicate numbers In A Column ?

 
 
Robert11
Guest
Posts: n/a
 
      16th Feb 2008
Hello:

Anyone have a link to a simple add-on that I can use to determine (easily)
if any numbers in a column are duplicates ?

Would like the duplicate numbers to be flagged as such; perhaps brought out
to a separate listing, or...

Thanks,
Bob


 
Reply With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      16th Feb 2008
Chip Pearson has some formulas and methods to flag duplicates.

http://www.cpearson.com/excel/Duplicates.aspx

See also at the bootom of the page about "preventing duplicates"


Gord Dibben MS Excel MVP

On Fri, 15 Feb 2008 20:05:31 -0500, "Robert11" <(E-Mail Removed)> wrote:

>Hello:
>
>Anyone have a link to a simple add-on that I can use to determine (easily)
>if any numbers in a column are duplicates ?
>
>Would like the duplicate numbers to be flagged as such; perhaps brought out
>to a separate listing, or...
>
>Thanks,
>Bob
>


 
Reply With Quote
 
Traveller
Guest
Posts: n/a
 
      18th Feb 2008
ASAP Utilities is a wonderful add-in (and FREE) and it does a great job
identifying duplicates. Go wo www.ASAP.COM.

"Robert11" wrote:

> Hello:
>
> Anyone have a link to a simple add-on that I can use to determine (easily)
> if any numbers in a column are duplicates ?
>
> Would like the duplicate numbers to be flagged as such; perhaps brought out
> to a separate listing, or...
>
> Thanks,
> Bob
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
duplicate numbers in a column crazygregie Microsoft Excel Misc 2 7th Feb 2009 01:36 PM
How can I find duplicate numbers within a column? =?Utf-8?B?SW1hIEJlZSBHaW5uZXI=?= Microsoft Excel Worksheet Functions 1 18th Jan 2006 09:18 PM
How can you find duplicate numbers in a column? =?Utf-8?B?QWx2aW4=?= Microsoft Excel Worksheet Functions 1 15th Jan 2005 11:24 PM
Duplicate numbers in column =?Utf-8?B?SGF5c2ll?= Microsoft Excel Worksheet Functions 1 30th Jun 2004 10:27 AM
Locating duplicate numbers in a column =?Utf-8?B?RGF2aWQ=?= Microsoft Excel Worksheet Functions 4 11th Mar 2004 03:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:52 AM.