Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch11/ExcelShorst64-67.xlsx
Learn how to create a single cell formula with the functions LET and BYCOL that will iterate columns in an array and spill multiple aggregate results vertically. The LET function defines an array and a function, which allows the array to be altered for calculations such as Geometric Mean. Thanks to ExcelLambda at YouTube for the Excel formula knowledge in this video : )

#excel #microsoft #excelisfun #excelcourses #excelcourse #excelfunctions #excelformula #excelfunction #365excel #office365 #office365training #exceltips #exceltutorial #exceltraining #exceltricks #excelmaster #excelmagictrick #excelmagic #short #excelshort
#bycol #let #letfunction #aggregate #spilling #dynnamicspilledarrayformulas