Excel Query: MAXIFS and MINIFS Functions to the Rescue

Опубликовано: 07 Июль 2020
на канале: Computergaga

3,372

In this video, we look at two solutions to an Excel query I received a few weeks ago.

I wanted a formula solution to the problem. The video shows one solution in modern Excel with the functions that have been introduced to Excel in recent years.

And then another solution that will work in versions Excel 2016 and before.

Learn more than 150 of the best Excel functions with 'Advanced Excel Formulas'
https://amzn.to/3Rg87Go

See if you can find your own solution using the file below and let me know in the comments.

Download the sample file to tackle the query - https://www.computergaga.com/_excel/f...

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