Aggregate Max versus Aggregate Large

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

Formula:

=AGGREGATE(14,6,RIGHT(A1:A10,2)+0,1)

but this doesn't

Formula:

=AGGREGATE(4,6,RIGHT(A1:A10)+0)

?

Thanks in advance

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

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

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