Build auto-updating top-performer rankings and multi-level leaderboards using SORT and SORTBY combined with FILTER.
This lesson is a free preview. No account is needed to read it.
The video for this lesson has not been published yet. The written lesson below is the full material for this session.
Practice live Excel formulas directly in your browser. Real calculation verified by HyperFormula.
Corporate reporting me static sorting tab break ho jati hai jab naya data enter hota hai. SORT aur SORTBY functions se aap live leaderboards create karte hain jo source data change hote hi automatically re-order ho jate hain.
=SORT(array, [sort_index], [sort_order], [by_col])
=SORTBY(array, by_array1, [sort_order1], [by_array2], [sort_order2], ...)
sort_order: 1 for Ascending (A-Z, low to high), -1 for Descending (Z-A, high to low).Agar hume Flipkart FCs ko pehle Region (Ascending) aur fir On-Time Delivery Rate (Descending) par sort karna hai:
=SORTBY(A2:E60, B2:B60, 1, E2:E60, -1)
FILTER aur SORT ko nest karke hum top performing hubs extract kar sakte hain:
=CHOOSEROWS(SORT(FILTER(A2:E60, B2:B60="South"), 5, -1), 1, 2, 3, 4, 5)
Or simply using TAKE:
=TAKE(SORT(FILTER(A2:E60, B2:B60="South"), 5, -1), 5)
[!WARNING] Agar
sort_ordermention nahi kiya jaye toh Excel default1(Ascending) assume karta hai. Leaderboards me revenue ya performance hamesha highest first dikhane ke liye-1pass karna mandatory hai.
Download the workbooks and cheat sheets used in this lesson.
5 questions on sort ordering, SORT vs SORTBY syntax, and multi-key leaderboard logic.
This quiz has 5 questions. Sign in to answer them — results are saved to your account.
Sign in to attemptSign in to submit your work for this assignment.
Stuck on a formula or edge case? Ask questions, upvote solutions, and earn community XP.
No questions yet on this lesson
Be the first to ask a doubt or start a discussion with peers and mentors!
Calculate total revenue in cell D6 by summing all items in column D (cells D2 to D5).
Every formula you enter is evaluated by a real spreadsheet engine in your browser — results are not pre-computed.
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit Price | Total |
| 2 | Laptop | 5 | 45000 | 225000 |
| 3 | Mouse | 20 | 500 | 10000 |
| 4 | Keyboard | 15 | 1200 | 18000 |
| 5 | Monitor | 8 | 12500 | 100000 |
| 6 | Grand Total |
Module 5: Executive Dashboards & Interactive Visuals
Module 6: VBA & Automation
Module 7: What-If Analysis, Finance & 3 Capstones