10.13 Concatenate members with the same ranking

 

Here below is a data table:

imagepng

Rank the students by math score, and concatenate the names of students having the same score with comma:

=spl("=E(?1).group(Maths).(~.(Name).concat@c()).rvs().new(#:Rank,~:Name)",A1:B12)

imagepng