Misterchipper
New Member
- Joined
- Jan 15, 2010
- Messages
- 28
Is there a quick and fast way to determine if a record is duplicated within a list? I have a giant list of about 10000 records and I am afraid that some of them are dupes...
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Duplicate Records
- Thread starter Misterchipper
- Start date
scottylad2
Well-known Member
- Joined
- Feb 2, 2009
- Messages
- 1,922
in B1 =Countif(A$1:A$10000,A1) and copy down, afterwards you can sort smallest to largest and you'll have any dups listed after all the once only entries
If you're not able to sort, then again in B1 IF(COUNTIF(A$1:A$10000)>1,A1,"") and you'll get a list of only the dups
If you're not able to sort, then again in B1 IF(COUNTIF(A$1:A$10000)>1,A1,"") and you'll get a list of only the dups
Last edited:
Upvote
0
Similar threads
- Question
- Question
