View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Michael is offline
external usenet poster
 
Posts: 18
Default Calculate every 5th Column.

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