Formula to find max values across variabe cells

[simonwait]

Hi

I have a formula in cell E26 which is

=MAX(K10,T10,AC10,AL10,AU10,BD10,BN10)

Then in E27 is

=MAX(K19,T19,AC19,AL19,AU19,BD19,BN19)

E28 is

=MAX(K23,T23,AC23,AL23,AU23,BD23,BN23)

This goes on for several cells. The trouble is that the number of cells i need to include changes and so i need to go through every formula and change what is in the MAX. Ideally I would like to just change what columns are in E26 and for the rest to then adjust accordingly (with their relative rows). Especially if i add or delete more rows in the MAX calc.

Is there an obvious way of doing this without using VBA?

Thanks in advance

[CAntosh]

Is there data in the next 9th cell (BW10 in your example), or is it just blank? The formula below will take the Max of every 9th row from column K through DZ (you can expand DZ to something bigger if need be):

=MAX(IF(MOD(COLUMN(K10:DZ10),9)=2,K10:DZ10))

This is an array formula, so confirm it with Ctrl + Shift + Enter instead of the regular Enter