#110 — Sorting of Row-Based Data — by Expression

Problem description & analysis: Here below is a data table: Task: Sort in reverse order by the sum of three columns, Maths, English, and PE. Solution: Use SPL XLL and enter the following formula: =spl("=E(?).sort(Maths+English+PE:-1)",A1:E12) The r...