How can I make Excel MAX function to return an array?

[pasunmaa]

I have an two-dimensional in cell array {0,2;3,0;0,5;6,0;0,0;0,8} and I would need to to get Max value of each column in a single cell. So, I would like to get {6,8} as a response from {=MAX({0,2;3,0;0,5;6,0;0,0;0,8})} instead of just 8.

0	2
3	0
0	5
6	0
0	0
0	8

<tbody>
</tbody>

In the next step I would prefer to get ROW number, where Max value is present?

I have tried everything, but can't make MAX to return an array. MAXIF would return an array, but it does not accept ROW function as max_range.

Are these actions doable with Excel formulas?

 

[XOR LX]

I wonder if you are aware any specification, blog article or similar describing which Excel functions support array-formulas?

Not sure what you mean here? Can you give an example of a function which you believe may not operate over an array?

Regards