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-...
★ 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-reas...
Dynamic Arrays - https://exceloffthegrid.com/dynamic-a...
FILTER - https://exceloffthegrid.com/filter-fu...
SORT - https://exceloffthegrid.com/sort-func...
SEQUENCE - https://exceloffthegrid.com/sequence-...
★ 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: / exceloffthegrid
#MsExcel #ExcelOffTheGrid