max of average
how would you take the max of an average in a situation such as this:
1 2 3
3 4 2
2 3 4
I want to average the rows, and then find the max of each of those
averages.
naturally this should be 3.
i think you have to use one of those control shift enter formulas, but
i'm not sure.
|