In this video, we will use the COUNTIFS function to create a conditional rank formula.
Although Excel has a RANK function to rank values in a list, it does not have a RANKIF function for conditional rankings.
The good news is though that there are ways to do it. In this video the everversatile COUNTIFS function (one of the best around) gets the job done.
Find more great free tutorials at;
https://www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1