Dynamic Array Rank-If

Summary: I am trying to create a "Rank If" calculation but with dynamic spillable arrays only.

I have tried using the filter function nested in rank along with the ByRows function.

Before I try anything too complex, it seems like there should be a relatively simple and clever solution that is just out of grasp. Spreadsheet sample has been uploaded and the following picture is for ease of reference:

Screenshot 2022-10-13 192814.png

To begin, Assume all of the following are spillable:
column F has some text identifiers like Name,
column G has some numerical value (>=0)

the desired output: Each Score is ranked for each Name. Joe's highest score would have a value of 1, second highest score a value of 2, and so on...

Thank you WBD.
However, to note anyone downloading the spreadsheet. The table was just inserted to easily create the spillable columns containing the data to demonstrate. There is no source table in the original problem.

But let me play around with your solution and see if I can implement the concept.

Somewhat long winded, but how about

Formula:

Please Login or Register  to view this content.

Yes, it worked like a charm. - Solved.

I simply replaced the table reference with a spillable column range:

=LET(t,$F$17#:$G$17#,MAKEARRAY(ROWS(t),3,LAMBDA(r,c,IF(c<3,INDEX(t,r,c),SUMPRODUCT((INDEX(t,,1)=INDEX(t,r,1))*(INDEX(t,,2)>=INDEX(t,r,2)))))))

For anyone searching, notable functions used: MakeArray

WBD - thank you for lending your intellect to this problem!