Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch11/ExcelShorst64-67.xlsx
Learn how to create dynamic spilled array formula to spill multiple aggregate clauctae using the AGGREGATE Function (Excel 2010 Function). This is an old school function that can do amazing things in the Era of Dynamic Spilled Array Fomulas.

#excel #microsoft #excelisfun #excelcourses #excelcourse #excelfunctions #excelformula #excelfunction #365excel #office365 #office365training #exceltips #exceltutorial #exceltraining #exceltricks #excelmaster #excelmagictrick #excelmagic #short #excelshort

AGGREGATE Function, Excel 2010, Spill aggregate formulas, Spill Multiple Different Aggregate Calculations