“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need a formula to calculate the maximum rows in excel as a range of 167 rows in column D, then find the MAX of the next 167 rows in column D and so on continuously through the entire sheet. Example MAX D2:D169, D170:D337, D338:D505 etc...

Solved by I. Q. in 29 mins

how to show the player with the hight score in excel using MIN and MAX

Solved by D. C. in 26 mins

I have two separate MAX formulas in cells M19/M20.#
i wish to have both formulas in a MAX fuction in M19.

Solved by C. S. in 24 mins

need to plot neighbourhood for matrix in my excel sheet with nearest value max 1 min 0

Solved by G. Q. in 17 mins

In Open Off. Calc I need a formula that finds the max value in a row of cells and then divides that max value by 6, IF the max value is in column D, and divides by 4 IF that max value is in column E, and divides by 2.4 IF that max value is in column F, etc. I tried =if(max(d3:i3)=d3)/6 and that worked fine to give me the correct fraction as a result (0.167) when the max value in the row was in d3 with a value in d3 of 1.00, but when I tried it with a value of 2.00 in the next row (d4) I got the same result of 0.167 when it should be 0.333. Then, when I tried =if(max(d3;i3)=d3)/6, if(max(d3:i3)=e3)/4 I got an Error 509. (formulas in column M)

Solved by C. J. in 29 mins