Copy a function but skip a few cells out

[martyloo]

I have a function in cell B1 which is =MAX(D8:D21)

in cell B2 I would like the function =MAX(J8:J21)
in cell B3 I would like the function =MAX(P8:P21)
in cell B4 I would like the function =MAX(V8:V21)

Is there a way of copying function in the cell below so it knows automatically to jump from (J8:J21) to (P8:P21) basically jumping the alphabet every 6 spaces for every function I copy down into the next cell?

Can anyone help?

 

[Snakehips]

martyloo,

Perhaps this...

Worksheet Formulas Cell Formula B2 =MAX(OFFSET((J8:J21),0,6*(ROW(B2)-2))) <THEAD> </THEAD><TBODY> </TBODY>

<TBODY>
</TBODY>

Drag B2 formula down as required.

Hope that helps.

 

[ukmikeb]

Hi

Try this in B1 :-

=MAX(OFFSET($D$8,,(ROWS($B$1:B1)-1)*6,14,1))

and drag down

hth