Results 1 to 1 of 1

Creating lists of names from table where the people meet certain criteria

Threaded View

  1. #1
    Registered User
    Join Date
    12-20-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Creating lists of names from table where the people meet certain criteria

    I have a table which has in the far left hand column a list of names. Running across the table are a list of characteristics. If the person named on the far left has the characteristic then a 1 is shown in the corresponding box (see Sheet one in my example).

    On the second sheet using a drop down box I want to be able to select a characteristic. Based on this selection I want to populate a list of all the people (names) who have this characteristic - i.e. all the people who are for example male. The drop down list can be changed at any point to select a new characteristic.

    Am sure this can be done using MATCH INDEX VLOOKUP etc.... just not sure how.

    Have included a dummy example to illustrate.

    Thanks
    Attached Files Attached Files

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