Join 400,000+ professionals in our courses here https://link.xelplus.com/ytdallcou...
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 dataset 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.
⬇ DOWNLOAD the workbook here: https://pages.xelplus.com/topvalues...
Instead of a complex formula with the LARGE function in a lookupformula 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.
Get access to the full course about the new Excel functions here https://www.xelplus.com/course/excel...
Check out the complete Excel for Office 365 playlist: • Excel for Office 365 & Dynamic Arrays
★ My Online Excel Courses ► https://www.xelplus.com/courses/
➡ Join this channel to get access to perks: / @leilagharani
☕ Get the Official XelPlus MERCH: https://xelplus.creatorspring.com/
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/coursequiz/
RESOURCES I recommend: https://www.xelplus.com/resources/
Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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!
#excel