Try, array-entered (press CTRL+SHIFT+ENTER):
=MAX(IF(MOD(COLUMN(E1:IV100),5)=0,E1:IV100))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michael" wrote:
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