I got top from data but unable to find 2nd and third on from given data. Please help excel sheet is attached
I got top from data but unable to find 2nd and third on from given data. Please help excel sheet is attached
Please try
=INDEX(SORTBY(UNIQUE($B$2:$B$28),SUMIFS($C$2:$C$28,$A$2:$A$28,E4,$B$2:$B$28,UNIQUE($B$2:$B$28)),-1),SEQUENCE(3))
Double aggregateFormula:=INDEX(B$2:B$21;AGGREGATE(15;6;ROW($1:$1000)/(C2:C$21=AGGREGATE(14;6;C$2:C$21/(A$2:A$1000=E$4);ROWS($5:5)))/(A$2:A$21=E$4);1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks