#109 — Sorting of Row-Based Data — by the Combination of Multiple Columns

Problem description & analysis:

Here below is a data table:

Task: Sort in reverse order by the order combination of three columns (Maths, English, and PE).

Solution:

Use SPL XLL and enter the following code:

=spl("=E(?).sort(Maths:-1,English:-1,PE:-1)",A1:E12)

The results are as follows:

---

Download esProc Desktop for FREE and enhance your Excel arsenal with SPL XLL! 🚀🔥⬇️

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming