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) |
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1656298205915
https://c.scudata.com/article/1656379654003
SPL Official Website 👉 https://www.esproc.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.esproc.com
Discord 👉 https://discord.gg/2bkGwqTj
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/
