Results 1 to 3 of 3

Separating unique values from a list

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2008
    Location
    Illinois
    Posts
    63

    Question Separating unique values from a list

    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
    Last edited by Nickster64; 05-11-2010 at 03:47 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1