10.6 Sort by specified order

 

Here below is a data table:

imagepng imagepng

Please add one column Score on the right of the column Name in the Student sheet, and fill in the data of column Score of the Score sheet in the added column. Calculate in cell C1 of Student sheet:

A
1 =E(‘A1:B17’)
2 return E(‘Score!A1:B12’).align(A1:Name,Name).new(~.Score)

imagepng


esProc Desktop and Excel Processing
10.5 Sort in group
10.7 Sort by specified order in which duplicate values exist