I think you were responding to
@Bosco's post. The '
14' and '
6' are magic parameters required by
AGGREGATE to determine which operation to perform. '
14' is equivalent to
LARGE and gives the
kth largest value, whilst the '
6' causes it to ignore errors. Bosco deliberately forced
#DIV/0! errors for the items he did not want to see included in the calculation. Another useful feature of the
AGGREGATE function in legacy Excel is that it acted as an array wrapper, allowing array formulas to be written without needing CSE.