Unique text strings

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

Hello,
I would like to remove all of the "repeats" from a list
of alphanumeric part numbers. The result should be a
list of unique text strings. For example:
AA1
AA1
AA1
AB1
AB2
AB2
AC5

would become
AA1
AB1
AB2
AC5

Does anyone know of a function that can perform this
action? It seems like a pretty simple thing. The best
idea I could come up with was to use an IF statement in
another column that returns a null value if the string is
a repeat, then sort that column & keep only the non-null
cells.
Any help would be greatly appreciated!
Thank you!
Barb
 
You can use data>filter>advanced filter, select copy to another location and
unique records only
if you need a formula and the data starts in A2, in B2 you can put

=INDEX($A$2:$A$200,MATCH(0,COUNTIF($B$1:B1,$A$2:$A$200),0))

enter it with ctrl + shift & enter and copy it down until you get an error

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top