Want to rank players for each session based on number of wins, games, and then points-CodePudding

I want to automatically decide who's 1st, 2nd, 3rd, and 4th for each session. I want it to be decided based on the number of match wins first, then game wins if matches are equal, and then points if games are equal. If everything is equal, then have 2 players as the same position and the next one skipped (1st, 2nd, 2nd, and 4th). The highlighted cells are where I want to calculate this. Can someone please help me with this?

Sample file:

Then wrapped it in LAMBDA in order to be used as the new source of RANKING, and calculated it with the help of BYROW. But now the ranking needs to be done in reversed order. The greater values are going to equal to the ones at the bottomo of the ranking and vice versa. That's why the 0 in RANK(e,r,0) :

=LAMBDA(r,BYROW(r,LAMBDA(e,RANK(e,r,0))))(MAP(B2:B5, C2:C5, D2:D5, LAMBDA(a,b,c,RANK(a,B2:B5)*100 RANK(b,C2:C5)*10 RANK(c,D2:D5)*1)))

Let me know!

NOTE: This would work great until 9 players, if you or anyone else needs it for more, you should change 100,10,1 with the amount of players 1 elevated to the "priority" of the category. The first one the highest. For example, for 15 players, I would multiply the first ranking by: 16^3,16^2 and 16^1. For 20 players and 4 categories: 21^4,21^3,21^2,21^1 - Hope it's clear for universalization!