Top 10 with formulas in Excel | Automatically calculate Top 10 as data changes | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Download the example file ★ https://exceloffthegrid.com/creating-a-top-10-using-formulas/ ★ About this video ★ It is easy to create a top 10 list when working with sorted data, Auto Filter, Tables and Pivot Tables. However, when creating a top 10 with formulas on a non-sorted dataset, things become a little bit tricky. In this video, I will show you exactly how to do it. ★ Learn more about the functions used in this video ★ INDEX / MATCH - https://exceloffthegrid.com/real-reason-index-match-better-vlookup/ Dynamic Arrays - https://exceloffthegrid.com/dynamic-arrays-in-excel/ FILTER - https://exceloffthegrid.com/filter-function-in-excel/ SORT - https://exceloffthegrid.com/sort-function-in-excel/ SEQUENCE - https://exceloffthegrid.com/sequence-function-in-excel/ ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel #ExcelOffTheGrid