★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]
★ Download the example file ★
[ Ссылка ]
★ 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 - [ Ссылка ]
Dynamic Arrays - [ Ссылка ]
FILTER - [ Ссылка ]
SORT - [ Ссылка ]
SEQUENCE - [ Ссылка ]
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
[ Ссылка ]
★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]
#MsExcel #ExcelOffTheGrid
Ещё видео!