+ Reply to Thread
Results 1 to 6 of 6

Return multiple values in a list based on multiple criteria

  1. #1
    Registered User
    Join Date
    01-06-2020
    Location
    israel
    MS-Off Ver
    excel 16.30 for MAC
    Posts
    5

    Return multiple values in a list based on multiple criteria

    Hi,
    I'm trying to return multiple values in a list (using a separator ",") based on multiple criteria

    Example:
    each row is a person.(assume 3 rows)
    each column is a month. (assume 3 columns)
    a person eats one fruit in a month.

    I need to extract per fruit & month criteria the list of all people who answer both criteria.
    i.e - apple & Jan should return "mike,john"

    Appreciate your help

    Yuval
    Attached Files Attached Files

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,430

    Re: Return multiple values in a list based on multiple criteria

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  3. #3
    Registered User
    Join Date
    01-06-2020
    Location
    israel
    MS-Off Ver
    excel 16.30 for MAC
    Posts
    5

    Re: Return multiple values in a list based on multiple criteria

    Thanks, Updated

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,885

    Re: Return multiple values in a list based on multiple criteria

    If I understand correctly then try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    01-06-2020
    Location
    israel
    MS-Off Ver
    excel 16.30 for MAC
    Posts
    5

    Re: Return multiple values in a list based on multiple criteria

    Thanks ! works perfectly

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,885

    Re: Return multiple values in a list based on multiple criteria

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. [SOLVED] Return Unique list based on Multiple Criteria
    By G.Bregvadze in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2017, 04:23 AM
  2. [SOLVED] Return Values based upon multiple criteria
    By frustrated in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2016, 08:56 AM
  3. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  4. [SOLVED] How to return multiple values to a single cell based on multiple criteria
    By lwallace in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2014, 06:32 AM
  5. Return list based on multiple criteria
    By Arcadia in forum Excel General
    Replies: 1
    Last Post: 03-13-2014, 01:54 PM
  6. Replies: 2
    Last Post: 03-03-2014, 10:03 PM
  7. Replies: 6
    Last Post: 07-26-2011, 04:36 PM

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