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


esProc Desktop and Excel Processing
10.12 Ranking of row-based data - by expression
10.14 Rank in group