Excel BI Challenge Workout 191

Workouts Excel BI Challenge
21

LinkedIn Post by:
Kris Jaganah

=LET(a,A2:A6,b,SORT(HSTACK(a,BYROW(B2:D6,LAMBDA(x,SUM(x)))),2,-1),c,TAKE(b,,1),XLOOKUP(a,c,XMATCH(c,c)))

22

LinkedIn Post by:
Sunny Baggu
 

=XMATCH(A2:A6,SORTBY(A2:A6,BYROW(B2:D6,LAMBDA(a,SUM(a))),-1))
23

LinkedIn Post by:
Krzysztof Nowak

My solution in hashtag#R

image
image730×680 95.1 KB

24

LinkedIn Post by
Nicolas Micot
 

=LET(_ranks;BYROW(B2:D6;LAMBDA(a;TEXTE(SOMME(a);"000")));
_ranksPlus;_ranks&"_"&TEXTE(10000-LIGNE(A2:A6);"00000");
_tri;TRIER(_ranksPlus;;-1);
BYROW(_ranksPlus;LAMBDA(a;EQUIV(a;_tri;0))))
25

LinkedIn Post by:
Amr Tawfik, CMA P1

=XMATCH(A2:A6,SORTBY(A2:A6,BYROW(B2:D6,LAMBDA(x,SUM(x))),-1),0)