Thread: max of average
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dmatrix00d@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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.