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:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks