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) |
esProc Desktop and Excel Processing
10.5 Sort in group
10.7 Sort by specified order in which duplicate values exist
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.scudata.com
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/
