playlistduration

Excel Ranking: How to Rank Values in Excel: Formulas, PivotTables, Power Query & Power Pivot DAX

by excelisfun · 14 videos

Total watch time

2h 18m

at 1× speed · exactly 2 hours, 18 minutes, 24 seconds at 1×

1×2h 18m 24s
1.25×1h 50m 43s
1.5×1h 32m 16s
1.75×1h 19m 5s
2×1h 9m 12s
Average video9m 53s
Longest27m 6s
Shortest2m 52s
Compare Open on YouTube JSON

Plan to finish

About 3 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 3 days. Turn on JavaScript to plan around your week.

Videos (14)

2h 18m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Slaying Excel Dragons Book #33: RANK Functions & Excel 2010 Compatibility Functions RANK.AVE RANK.EQ 5:27 2013-03-04
2 Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank 20:55 2015-01-24
3 Excel Magic Trick 1417 Excel Functions Ranking Unit & Total Profit for Products within Manufacturer 12:10 2017-05-09
4 Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer 14:28 2017-05-11
5 Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer 27:06 2017-05-12
6 Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns 12:51 2017-05-14
7 Excel Magic Trick 1135: Rank Values From Two Columns: RANK.AVE, RANK.EQ & RANK Functions 7:43 2014-07-28
8 Excel 2010 Magic Trick 667: AGGREGATE Function Array Formula #2 Return 5 Largest Values 7:49 2010-07-22
9 Excel Magic Trick 1354: Rank with Criteria: Rank Football Teams by Total Wins & Division Wins 6:15 2016-12-04
10 Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR 2:52 2014-04-21
11 Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rank 4:36 2010-07-12
12 Excel Magic Trick 344: MAX IF & RANK functions without Zeros 6:31 2009-07-24
13 Excel Magic Trick 707: RANK with Criteria - SUMPRODUCT 5:57 2010-09-03
14 How to Rank in Power Query. EMT 1698 by excelisfun. 3:44 2020-11-02

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 2h 18m · 14 videos

Markdown
[![Watch time: 2h 18m · 14 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0kcyde3E5ZgIwXTn_mCuZq1.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0kcyde3E5ZgIwXTn_mCuZq1)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0kcyde3E5ZgIwXTn_mCuZq1"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0kcyde3E5ZgIwXTn_mCuZq1.svg" alt="Watch time: 2h 18m · 14 videos" width="203" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0kcyde3E5ZgIwXTn_mCuZq1 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.