LinkBack URL
About LinkBacks
fretwizard 
I have to compile spreadsheets as tables of various values. One column in particular is a column of ID numbers and the worksheet is very very long. I need a method for checking this one column for duplicate ID numbers. Please help
Thanks in advance!
I have to compile spreadsheets as tables of various values. One column in particular is a column of ID numbers and the worksheet is very very long. I need a method for checking this one column for duplicate ID numbers. Please help
Thanks in advance!
Last edited by oldchippy; 11-06-2008 at 08:33 AM.
Hi,
Can you not sort the by the ID?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
well i was just wondering if there was a formula/process that would highlight or something like the the duplicate numbers. i can copy>paste into a new worksheet then sort on go over the list but it is hundreds of numbers??
Last edited by fretwizard; 11-06-2008 at 08:20 AM.
Try this in B1, copied down
=IF(COUNTIF(A:A,A:A)>1,"Duplicate","")
LIKE A CHARM!! thanks chippy!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks