Excel Rank Top N Values Inc Tied Values with Dynamic Array Formulas

In this video, we create a dynamic ranking of top n values using Excel formulas only.

The user can select if they want to see the top three, top 5 or top eight from a list and the rankings dynamically change.

The formulas also handle the problematic scenario of tied values. Tied values are assigned the same rank, and the rankings then adjust accordingly.

Tasks such as this are made so much easier with dynamic arrays formulas such as FILTER and SEQUENCE. Both play a pivotal role in this solution. A few other friends come to help too.

You can download the file to follow along here - https://www.computergaga.com/_excel/files/ranking-with-das.xlsx

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1

Видео Excel Rank Top N Values Inc Tied Values with Dynamic Array Formulas канала Computergaga