Sorry I didnt really know how to phrase my subject line. My data is arranged like this:I need a unique list of each of those 6 digit codes. Only way I can figure it is a long way around:
Please Login or Register to view this content.
1) used excels Duplicate Finder to get my unique fields (for instance, in the above lines 2 and 3 match, so DupeFinder would delete one).
2) Use TextToColumns to separate each 6-digit code
3) Put them all in a column and used Advance filter to get a list of unique values.
Is there a better way?