Aggregate Max versus Aggregate Large

[ChemistB]

With a series in A1:A10 of strings where the last 2 characters are numbers,
why does this work

Please Login or Register  to view this content.

but this doesn't

Please Login or Register  to view this content.

?

Thanks in advance

[XOR LX]

Hi ChemistB,

Not sure why MS designed it so, but only with a function_num parameter of 14 and above will AGGREGATE accept arrays (including those, as in your example, which are derived 'in-formula' via some other construction).

Regards

[Bo_Ry]

There are 2 types of Syntax
Function num 1-13 is for Reference form

AGGREGATE(function_num, options, ref1, [ref2], …)
Ref refer to range only

Function num 14-19 is for Array form
AGGREGATE(function_num, options, array, [k])
array can be array, range, array constant

[ChemistB]

Thanks, I figured it was a design thing but wanted to make sure I wasn't missing something obvious.