Excel's AGGREGATE Function Doesn't Work Like You Think
★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-... File Reference for this video: 0323 Visible + Condition ★ JOIN THE FREE COURSE ★ Want to get the free Modern Excel Formulas course? Click here: https://exceloffthegrid.com/modern-ex... ★ Want to become an Excel ninja? Check out our training academy ★ https://exceloffthegrid.com/ ★ About this video ★ AGGREGATE is one of Excel's best functions. But... many users discover its limitations when it suddenly starts returning the #VALUE! error. In this video, I'll explain: 1) Why AGGREGATE breaks 2) The basic workaround for all versions of Excel 3) The advanced workaround for modern Excel 00:00 Introduction 00:44 The AGGREGATE function 02:23 Arrays vs ranges 05:25 Include column 08:52 BYROW / LAMBDA 11:29 Wrap up + free course ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: / exceloffthegrid #MsExcel
The Best Lookup Function Nobody Talks About... FILTER
Excel vs Power BI vs SQL vs Python | Grouping 37,000 Marathon Finish Times
VLOOKUP, XLOOKUP & INDEX MATCH ON LARGE DATA
Drop‑Down Lists From Tables: Stop Using INDIRECT (Do This Instead)
Why Measures Don’t Work in Slicers (And How to Fix It.)
Power Query Secrets - Simple tweaks is all it takes.
99% of People Use Microsoft Outlook Wrong
Find & Replace Can Do This? (Most People Have No Idea)
Unpivot Multiple Header Rows in Excel (Faster Method)
God Says:"DON’T IGNORE THIS IMPORTANT LETTER I SENT YOU"/God Message Now/God Message
Experienced Excel Users Are Replacing IF With These Functions
Shocking Confirmation That Liquid Water Is Two Separate Substances
I don't use VLOOKUP or XLOOKUP in Excel anymore, I do this instead
Android 17 sucks. So I put Linux on a phone.
These 5 Custom Column Tricks Make Power Query Easier
How to Keep Manual Changes with Power Query... It's Easy When You Know How!
Excel Checkboxes... More Powerful Than You Think
8 Tiny Excel Symbols That Replace Messy Formulas
One Column Change Destroys Everything... Unless You Do This!
