...
10.6 Sort by specified order
Here below is a data table:
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) |
