How to use the Excel AGGREGATE function | Exceljet
AGGREGATE can handle many array operations natively, without Control + Shift + Enter. AGGREGATE can run a total of 19 functions, and the function to perform is given as a number, which appears as the first argument in the function, .