+ Reply to Thread
Results 1 to 6 of 6

Using multiple drop-downs to filter list to produce final unique list

  1. #1
    Registered User
    Join Date
    03-01-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    4

    Using multiple drop-downs to filter list to produce final unique list

    I'm working on a project that requires modeling a basic multiple-input and multiple-output engine via Excel.

    To keep things simple, let's use the following as a proxy:

    Given:
    100 unique people.

    Solve for:
    Individuals of the 100 who fit certain characteristics:

    Characteristics:
    Physical
    Eye color (blue, brown),
    Height (below 5', between 5' and 6', taller than 6')
    Hair color (white, blonde, brown, black)
    Emotional
    Social (outgoing, shy)
    Expression (verbal, nonverbal)

    Where I am:
    Multiple dependent drop-down menus for each characteristic using named lists and data validation
    EX:
    I can tell you the names of the 23 people with brown eyes, the 15 people taller than 6', OR the 33 people with black hair in drop down menu form

    Where I want to be:
    A single list that identifies the 7 people with brown eyes AND taller than 6' AND black hair by name/in list form!

    Issue:
    I need a list as an output, not a single value output.

    I would prefer NOT to make this into an absurdly-long conditional statement (IF blue eyes, THEN white hair OR black hair OR...etc)

    Thank you so muuch!!!!

    ----

    PS: Actual engine has many many more variables and lists

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Using multiple drop-downs to filter list to produce final unique list

    Hi, welcome to the forum

    Sounds like you need to use INDEX/SMALL/IF combo, but hard to be more specific without seeing a sample of what you are working with.
    (or create a helper column/s that contain a combo of all your variables and search based on that)

    Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Using multiple drop-downs to filter list to produce final unique list

    Have you tried using AutoFilter? This is pretty much what it was made for.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    03-01-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    4

    Re: Using multiple drop-downs to filter list to produce final unique list

    Thank you both. FDibbins, I'll send you a private message with the attachment.

    Tony Valko, I'll look into autofilters...

    Thank you.

  5. #5
    Registered User
    Join Date
    03-01-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    4

    Re: Using multiple drop-downs to filter list to produce final unique list

    clean-model.xlsx

    clean-model.xlsx

    Okay...couldn't figure out how to send it in the messages, so here is a sample...

  6. #6
    Registered User
    Join Date
    03-01-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    4

    Re: Using multiple drop-downs to filter list to produce final unique list

    Oh shoot. Please look at this one instead.clean-model.xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 06-28-2013, 03:49 PM
  2. Produce a result from a drop down list
    By Emz1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2009, 02:20 AM
  3. Lists/drop downs creating more than one sub list?
    By Zhola in forum Excel General
    Replies: 6
    Last Post: 10-31-2007, 01:12 PM
  4. Replies: 3
    Last Post: 01-16-2006, 02:10 AM
  5. list added to list using drop-downs
    By karambos in forum Excel General
    Replies: 0
    Last Post: 04-27-2005, 07:25 AM

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