Extract Top 5 Values with Names with Dynamic Array Formulas & Conditional Formatting – EMT 1610

Download Excel File: https://ift.tt/33dB3Gd
Learn how to extract top five scores and names of people with the score, including when there are ties or duplicates. Learn about Office 365 Excel Dynamic Array Functions like FILTER and SORT, lean about how the new Excel Calculation Engine Spills the results so we do not have to copy formulas, and learn about how to add Conditional Formatting to Spilled Results.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.