Find the top 10 values with one Excel formula. This video shows you how to apply a formula to 10 cells in one go to return the top 10 values and other data associated with them.

Think you need to improve your Excel formula skills?
Enrol in the Ultimate Excel online course - [ Ссылка ]

This video tutorial uses an array function with LARGE to return the top 10 values. And INDEX and MATCH formula is then used to fetch related data.

Find more great free tutorials at;
[ Ссылка ]

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]

Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]

свернуть