DEV Community

Cover image for #109 — Sorting of Row-Based Data — by the Combination of Multiple Columns
Judith-Excel-Sharing
Judith-Excel-Sharing

Posted on

2 1 1 1 1

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

Problem description & analysis:

Here below is a data table:

source 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:

result table


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

Image of Bright Data

Maintain Seamless Data Collection – No more rotating IPs or server bans.

Avoid detection with our dynamic IP solutions. Perfect for continuous data scraping without interruptions.

Avoid Detection

Top comments (1)

Collapse
 
judith677 profile image
Judith-Excel-Sharing

Elevate your data analysis skills and say goodbye to Excel struggles!

💎Discord
💎Reddit

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Immerse yourself in a wealth of knowledge with this piece, supported by the inclusive DEV Community—every developer, no matter where they are in their journey, is invited to contribute to our collective wisdom.

A simple “thank you” goes a long way—express your gratitude below in the comments!

Gathering insights enriches our journey on DEV and fortifies our community ties. Did you find this article valuable? Taking a moment to thank the author can have a significant impact.

Okay