+ Reply to Thread
Results 1 to 6 of 6

Multi criteria get a list from high to low

  1. #1
    Forum Contributor
    Join Date
    10-02-2021
    Location
    Thailand
    MS-Off Ver
    365
    Posts
    174

    Multi criteria get a list from high to low

    According to the date, Type gets Code/Name/Total amount

    Add the same name amount

    B4:D6 is the ADULT list and the final result
    F4:H6 is the CHILD list and the final result

    Can someone please help me ? It would be much appreciated. Thanks in advance
    Attached Files Attached Files
    Last edited by choletseng; 01-19-2022 at 10:41 AM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Multi criteria get a list from high to low

    Please try
    =LET(z,L2:P43,st,B1,en,D1,t,B2,c,INDEX(z,,1),d,INDEX(z,,4),u,UNIQUE(SORT(FILTER(c,(d>=st)*(d<=en)*(INDEX(z,,5)=t)))),CHOOSE({1,2,3},u,VLOOKUP(u,z,2,),SUMIFS(INDEX(z,,3),c,u,d,">="&st,d,"<="&en)))
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-02-2021
    Location
    Thailand
    MS-Off Ver
    365
    Posts
    174

    Re: Multi criteria get a list from high to low

    Wow, @Bo_Ry'S great, this formula is amazing, thank you so much for your kind help

  4. #4
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Multi criteria get a list from high to low

    I think it's intended to sort descending on the total sums so perhaps a small amendment:

    Please Login or Register  to view this content.
    And then for the other one:

    Please Login or Register  to view this content.
    Of course, it also might be limited to the top 3 so may need an extra step to extract the top 3 values.

    WBD
    Office 365 on Windows 11, looking for rep!

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Multi criteria get a list from high to low

    Pl see file. Column R and S are helper columns
    Formulas are given in B4:D7 and F4:H7
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  6. #6
    Forum Contributor
    Join Date
    10-02-2021
    Location
    Thailand
    MS-Off Ver
    365
    Posts
    174

    Re: Multi criteria get a list from high to low

    @WideBoyDixon and @kvsrinivasamurthy Thank you both, the problem has been solved

+ 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] Multi conditional formula to differentiate between high and low values and rate
    By BossZues in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-07-2022, 03:08 PM
  2. [SOLVED] Multi criteria INDEX/MATCH in multi-column FILTER spill range
    By Coley356 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2021, 04:23 PM
  3. [SOLVED] Retrieve SELECTED values from multi criteria list box into a cell
    By liamfrancis2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2017, 06:40 AM
  4. [SOLVED] Regular formula or array for multi colum multi criteria?
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-25-2016, 01:40 PM
  5. [SOLVED] For a multi-criteria match, return the value closest to current value in list
    By FraserMBrowning in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2015, 06:16 AM
  6. New & Lost: Multi Criteria & Multi Row INDEX, SMALL, MATCH...
    By morleyp in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-23-2014, 12:40 PM
  7. Large multi criteria / Vlookup/Choose Multi criteria
    By deanusa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2014, 01:48 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