Here below is a data table:

The task is to rank the students by score, and arrange the names with the same score into the same row. The result is as follows:

Script:

=spl("=E(?1).group(-Score).([#]|~.(Name))",Sheet1!A1:B25)

Group by Score and sort in reverse order; loop through each group, and merge the group number and the name of students in the group into a sequence.

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1658111369913
https://c.scudata.com/article/1658194758110