⬇ Download free Excel example file: https://bit.ly/fnagg1
The AGGREGATE function is the Swiss Army Knife of functions; it’s so versatile it can replace these 19 Excel functions in one fell swoop:
AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV.S, STDEV.P, SUM, VAR.S, VAR.P, MEDIAN, MODE.SNGL, LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC
But that’s not reason enough to use it, the functionkiller reason to use AGGREGATE over any of the 19 standard functions it can replace is because it is far more powerful. Let me show you.
LEARN MORE
===========
LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/
EXCEL NEWSLETTER join 320K+ subscribers here: https://www.myonlinetraininghub.com/e...
SUBSCRIBE if you’d like more tips and tutorials like this.
Please leave me a COMMENT. I read them all!
FOLLOW me on LinkedIn: / myndatreacy
SHARE this video and spread the Excel love.
Or if you’re short of time, please click the
EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
==============
0:00 The Swiss Army Knife of functions
0:19 The problem with other functions
1:00 Array or Reference Form
1:54 Handling arrays
2:59 Exploiting errors
4:38 Caution
5:03 Limitations
#excelfunctions #excelformula #exceltutorial