+ Reply to Thread
Results 1 to 3 of 3

Match Multiple Criteria INDEX & Aggregate

  1. #1
    Registered User
    Join Date
    11-02-2016
    Location
    Bellingham
    MS-Off Ver
    2010
    Posts
    26

    Match Multiple Criteria INDEX & Aggregate

    Hello,
    I am teaching to kids and I am trying to make an easy schedule by using the data I collected from the registration.
    the issues are that I have multiples option (3half day am,3half day pm ,3 full day, 5 half day AM,5 half day Pm, 5full day.... ) and the file I am using just use YES and NO for each category.
    What I am trying to do is to have the list of the kids separated by day and AM or PM.

    My example will be more helpful that my clumsy English and I very much apreciate your help.
    Merci,
    Rémy
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Match Multiple Criteria INDEX & Aggregate

    Hello, the below should work for you - but the layout of your data is not conducive to simple calculations.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For ease of reference I have attached a working example.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-02-2016
    Location
    Bellingham
    MS-Off Ver
    2010
    Posts
    26

    Re: Match Multiple Criteria INDEX & Aggregate

    XLent,
    It work perfectly and I really appreciate your effort to help me.
    Remy

+ 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. Dynamic Sort via Index/Match/Aggregate
    By datbigdog in forum Excel General
    Replies: 9
    Last Post: 06-15-2019, 09:02 PM
  2. [SOLVED] Create List - Index Match or Index Aggregate or other?
    By bambamclint in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-10-2019, 01:30 PM
  3. [SOLVED] Match two criteria and return multiple records - INDEX & AGGREGATE, TEXTJOIN function
    By remyte in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2019, 01:53 PM
  4. [SOLVED] INDEX-AGGREGATE with OR criteria
    By Glenn Kennedy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-16-2018, 09:32 AM
  5. [SOLVED] Index/Aggregate/row match with conditions, pivot summary replacement
    By Shruder in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2018, 08:36 AM
  6. Need help in Index, Match usage to match multiple criteria in sum function
    By Summer0830 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2017, 02:47 AM
  7. Replies: 2
    Last Post: 09-27-2014, 04:34 PM

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