+ Reply to Thread
Results 1 to 2 of 2

List of choices, how do i assign them?

  1. #1
    Registered User
    Join Date
    06-13-2018
    Location
    USA
    MS-Off Ver
    Office '16
    Posts
    1

    List of choices, how do i assign them?

    Background: Out of a group of 100 people, 11 have been assigned the task of communicating with the other 89. I asked these 11 who they are able to reach out to, so 11 individuals gave me names of other individuals they can contact, out of a list of 100 (including themselves).

    Each of these 11 people has given me a list - each of varying length - of people that they can contact. In my spreadsheet, I have listed each of these 11 names in row 1 and the 100 names in column a. If person in C1, for example, knows person in A30, there is a "1" in cell C30.

    How can I create a list of names for each of the 11 people to contact, based on the lists they gave me? Because some people gave a list of 5 and others a list of 25, there are some people (in Column A) that are on three lists and some that are on zero. Is there a way to assign each of the 11 people a list of 9-10 people to call, based primarily on who is on their list?

    I've included the file below, with the names taken out. If anything wasn't clear, I'll try to explain more. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-07-2018
    Location
    Newcastle Upon Tyne, England
    MS-Off Ver
    365
    Posts
    143

    Re: List of choices, how do i assign them?

    If you highlight cells B1:L1 and then go to Data and Filter you can then click on each filter and un-tick (Blanks) and click OK then it will leave you with the names that person needs to contact.

    Hope this helps!

+ 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: 0
    Last Post: 04-15-2013, 09:22 AM
  2. typing i a list box to narrow choices?
    By NinjaBear in forum Excel General
    Replies: 3
    Last Post: 07-02-2012, 11:46 AM
  3. Drop-down list choices restricting choices of other lists?
    By not_quite_excelling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2011, 06:04 AM
  4. Separating values from List Box choices
    By h_aesa1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2009, 10:59 AM
  5. Drop Down List -- More Choices?
    By cybercab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2007, 12:40 PM
  6. Text box to search a list box choices
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2007, 07:49 PM
  7. How do I allow multiple choices in a list-box?
    By rmcgreg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2006, 02:10 PM
  8. [SOLVED] Drop-Down List does not display choices
    By Bill Freeze in forum Excel General
    Replies: 1
    Last Post: 06-14-2005, 11:05 AM

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