Hi Michael

Try the array entered formula
{=MAX(IF(MOD(COLUMN(A1:CL1),5)=0,A1:CL1))}

Use Control+Shift+Enter (CSE) to commit or edit the formula rather than
just Enter.
When you use CSE, Excel will insert the curly braces { } for you - do
not type them yourself.
--
Regards

Roger Govier


"Michael" wrote in message
...
I have a request that has defeated me.


I would like to calculate the maximum value of the 5th consecutive
columns up 95(19*5).

I.e the maximum vale in column E,J,T,Y etc
NO VBA please.

Thanks