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


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1656637647746
https://c.scudata.com/article/1656739467025