# Multi criteria get a list from high to low

1. ## Multi criteria get a list from high to low

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

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

2. ## Re: Multi criteria get a list from high to low

=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)))

3. ## 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. ## 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

5. ## 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

6. ## Re: Multi criteria get a list from high to low

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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