Premium Only Content

Create an Interactive Top N Report in Excel (includes duplicate values) with Filter Function
7 May 2020 Excel for Office 365 & Dynamic Arrays
Add this interactive report to your Excel dashboard if you want to make an impression! It's INTERACTIVE so the user can decide which TOP N records of a data-set they'd like to see. It will also NOT have a problem with showing MULTIPLE MATCH results either! This way you get to quickly rank the data and categories automatically and be able to show duplicate values with their correct categories.
Instead of a complex formula with the LARGE function in a lookup-formula like INDEX & MATCH, VLOOKUP, or XLOOKUP we will use my new favorite Excel function: The FILTER function! Together with the SORT function we will create a simple formula to extract the data automatically. Both functions are available exclusively in Excel for Office 365 with the new Excel Dynamic Arrays features.
We will even improve the report and make sure the user cannot input a number that's exceeding the available options in the data set. This will help avoid the #Spill error. To do that we'll use a combination of the COUNT formula and the SEQUENCE function.
★ Want to learn more about the NEW Excel? Check out my course: https://courses.xelplus.com/p/excel-dynamic-array-formulas
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-top-values-filter-function
Check out the complete Excel for Office 365 playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
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
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/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 #Excel #LeilaGharani
-
LIVE
Sarah Westall
1 hour agoNew Study: EMFs Literally Put You into a Brainwave Cage; Reclaiming your Mind w/ Ian & Philipp
428 watching -
1:13:25
Kim Iversen
4 hours agoAmerica First? Then Why Are We Funding This? | Empathy Is the Left’s Weapon—Here’s Why It’s Dangerous
81.5K69 -
1:24:11
vivafrei
5 hours agoCanadian Elections! Trump Tariffs! Panicans and Hysterics! And Jena Griswold for AG of Colorado?
72.6K35 -
LIVE
2 MIKES LIVE
4 hours ago2 MIKES LIVE #202 Deep Dive Monday!
157 watching -
UPCOMING
BIG NEM
44 minutes agoQuit or Keep Going? A Real Talk for Creatives
1 -
LIVE
Quite Frankly
5 hours ago"Cringefest Protests, Trade War, 'Built Different'" ft. Brenden Dilley 4/7/25
1,207 watching -
1:30:45
Redacted News
4 hours agoBOMBSHELL TRUMP TARIFFS CAUSE LIBERAL MEDIA MELTDOWN AS MARKET SELLOFF GRIPS WALL STREET | Redacted
140K161 -
2:23:12
The Quartering
7 hours agoTrump's Tariffs Are WORKING, RFK Betrayal, Ben Shapiro Vs Trump & Tesla Protesters EXPOSED!
209K108 -
44:28
Kimberly Guilfoyle
5 hours agoThe Truth About Tariffs, Plus the De-Banking Battle, Live with Jeremy Tedesco & Elaine Dezenski | Ep211
50.4K18 -
9:08:36
LFA TV
1 day agoLFA TV - ALL DAY LIVE STREAM 4/7/25
136K35