Excel RANK without Skipping Numbers (Top 3 Report with Duplicates)
March 14, 2019 Excel Advanced Formulas & Features
Learn how to rank duplicate values in Excel without skipping numbers in the sequence. I also show you how the RANK function works and the difference between Rank.EQ and Rank.AVG functions. We also take a look at understanding how complex Excel array formulas such as SUMPRODUCT with criteria works by breaking down the formula.
0:00 How to use the Excel RANK function
0:51 RANK Function & RANK.EQ
3:30 RANK duplicates but don't skip numbers in between
6:51 Top 3 Report
8:51 SUMPRODUCT & COUNTIF Excel Array formula explained
You might need to create a top 10 or top 3 report in Excel. For example you'd like to get the top 3 values but there are two categories that have the exact same value and both are considered number 2. How can you show both categories as number 2 and not just the first one? VLOOKUP will not help here, because it will return the first match. You'd like ALL matches returned. The solution uses the SUMPRODUCT function together with the Excel COUNTIF function to get the ranking. We then use the TEXTJOIN and IF functions together as an array to get the category names ranked in ascending order.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-rank-without-skipping-numbers/
LINKS to related videos:
Excel TextJoin Function - https://youtu.be/TMZEUlFGp1U
Excel Lookup Formulas Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
Right Side Broadcasting Network
21 hours agoLIVE: President Trump Keynotes the Faith and Freedom Coalition's "Road to Majority" - 6/22/24
102K136 -
LIVE
Jewels Jones Live ®
22 hours agoBIDEN'S DECLINE | A Political Rendezvous - Ep. 81
1,323 watching -
23:11
Chicks in the Office
3 hours agoFinish This Quote From Miss Congeniality - Pop Culture Trivia: Beat Ria & Fran Game 129
4651 -
LIVE
GamingWithHemp
3 hours agoLegend of Zelda Parallel Worlds Episode #4
333 watching -
1:20:52
Michael Franzese
22 hours agoMichael Franzese LIVE! | Democrat Failures & The Upcoming Election | Ep. 8
16.3K18 -
8:36
Adam Does Movies
18 hours ago $5.34 earnedThe Bikeriders Movie Review - It's Not What You Think
58K13 -
LIVE
LFA TV
7 hours agoTRUMP PHILADELPHIA RALLY LIVE @1PM EST
2,641 watching -
59:26
Trumpet Daily
1 day ago $3.29 earnedHamas Has a Friend in the Biden Administration - Trumpet Daily | June 21, 2024
18.5K36 -
1:13:51
Edge of Wonder
23 hours agoCIA Remote Viewed Jupiter, New Spider-Man Mandela Effect & Weird News
48.5K26 -
1:41:29
2 MIKES LIVE
22 hours ago2 MIKES LIVE #81 OPEN MIKE FRIDAY!
27.8K6