I have a column full of unique values but many of them are repeating. I am looking for a quick way to make a list of each of the unique values and not include the repeating values.
For example I have the following in column A:
ABC
ABC1
ABC2
ABC3
ABC
ABC3
ABC2
ABC1
I want to make a separate list in column B with only the unique values of the original list. So it would look like:
ABC
ABC1
ABC2
ABC3
Thank you much!
Nick
Bookmarks