User Profile
Ilgar_Zarbaliyev
MCT
Joined 6 years ago
User Widgets
Recent Discussions
Re: How to find top 3 from each category using Excel dynamic formula?
By the way, ChatGPT recommended the following solution : =LET( srcNames, $A$2:$A$20, srcVals, $B$2:$B$20, u, UNIQUE(srcNames), n, ROWS(u), repNames, SORT(INDEX(u, MOD(SEQUENCE(n*3)-1, n)+1)), ranks, MOD(SEQUENCE(n*3)-1, 3)+1, percs, MAP( repNames, ranks, LAMBDA(nm,k, LARGE( FILTER(srcVals, srcNames = nm), k ) ) ), HSTACK(repNames, percs) ) This is one formula that provides your desired output.Re: How to find top 3 from each category using Excel dynamic formula?
It might not be exactly as you requested, but I kept the solution in two steps to keep it simple. Social Media =SORT(LET( u, UNIQUE($A$2:$A$20), n, ROWS(u), INDEX(u, MOD(SEQUENCE(n*3)-1, n)+1) )) Percent =LET( nm,H2, k, COUNTIF( H2:$H$2, nm), LARGE(FILTER($B$2:$B$20, $A$2:$A$20=nm), k) )
