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.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]0[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

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