Excel AGGREGATE Function
What is the Excel AGGREGATE Function? The Excel AGGREGATE function returns an aggregate calculation from 19 available function with eight available options. AGGREGATE Syntax AGGREGATE(function_num, options, ref1, ref2) function_num, required, a function to use (1-19). options, required, which values to ignore (0-7) ref1, required, the first …