Published On Nov 14, 2023
⬇️ Download free Excel example file: https://bit.ly/fn-agg1
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 function-killer 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