Gary,
You probably found my issue. Unfortunately, I also just realized I have some non-unique records in that field. I have several thousand records so trying to figure out the exact culprits might take me a minute. Hopefully once I resolve the non-unique issue, I'll be able to proceed with your solution.
Thanks.
------------------------------
Aaron B
ab1692@att.com
------------------------------
My preferred way to quickly check duplicates is to dump the CSV into Excel and use the formula below. A:A should be the column with potential duplicates, and A1 should be your first row of data in the same column.
=COUNTIF(A:A,A1)
The result will show how many instances of duplicates each value has. You can then filter the list to show all values that are not "1" to see your dupes. I prefer using this over (or before) Excel's "remove duplicates" because it shows you the dupes first in case you wanted to review.
Wow! That excel tip you provided just helped me uncover something we weren't aware of. This .csv was supposedly a list of "Unique" identifiers in the column but with the thousands of entries, nobody realized there were dozens of duplicates.
Thanks so much for that additional suggestion.
Once I get that problem fixed, I'll be able to get back into fixing my original issue.
v/r....Aaron
