+ Reply to Thread
Results 1 to 2 of 2

Create a Shorter List of Values - Help!

  1. #1
    Registered User
    Join Date
    06-01-2008
    Posts
    2

    Create a Shorter List of Values - Help!

    I need some help. I have some large tables showing the names of various managers and their empolyees they manage. In column 1 is the list of the various managers, and in column two are the names of the associates. The manger names repeat frequently. For example:

    Bob
    Bob
    Bob
    Bob
    Jane
    Jane
    Jane
    Kevin
    Kevin
    Kevin
    Kevin
    Kevin

    I want to use the form control options and create a drop down menu showing the list of possible managers....but I don't want the list to show any repeating values. I know that I can manually create a list with single values for each manger, but I'm wondering if there's an easier way.

    Is there a way to take a list of data that has repeating values, and then have Excel summarize the list to exclude repeating values?

    Thanks!

  2. #2
    Registered User
    Join Date
    01-30-2009
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    67

    Re: Create a Shorter List of Values - Help!

    go to Data>>Filter>>Advanced Filter
    Select the range of the names for "List range" field and check "Unique records only". You can filter the list in place or copy to another location.

+ 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