+ Reply to Thread
Results 1 to 4 of 4

Create list of Unique values based on Worksheet Data

  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    Victoria, BC
    MS-Off Ver
    Excel 2003
    Posts
    42

    Create list of Unique values based on Worksheet Data

    Hello Everyone,
    I have a worksheet with a whole bunch of locations in it (they all appear multiple times )
    I would like to create a list of each location ( appearing just once ) to build a lookup table from.

    Can someone help me with the quicket and easiest way to do this?

    Thank you.
    Last edited by todmac; 02-09-2012 at 08:19 PM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Create list of Unique values based on Worksheet Data

    1) Highlight the column of values
    2) Activate the Data > Filter > Advanced Filter
    3) Copy to another location > Unique Values only
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Create list of Unique values based on Worksheet Data

    todmac,

    You could use AdvancedFilter Unique.

    If column D had a title locations, you could highlite column D

    Click on Data

    Filter

    Advanced Filterů

    Click on the radio button Copy to another location

    In the Copy to: box type in N1

    where N1 is an available blank column

    click on the box for Unique records only

    And, click on the OK button.

    There is your unique list of locations.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  4. #4
    Registered User
    Join Date
    01-12-2011
    Location
    Victoria, BC
    MS-Off Ver
    Excel 2003
    Posts
    42

    Re: Create list of Unique values based on Worksheet Data

    Thank you everyone.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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