how to repeat Max numbers from one column to other withing loop ?

[shalhoob]

Hi everyone. Hope you doing ok.

Ive got a question about adding max numbers of one column for each 48 cells to another column!

in this logic
for i=1 to 13002 (step or increment of 48 i.e. 1,48,96,....)

Di = max (Ai:Ai+47)

loop

where Di is the clumn cells that contains daily max numbers of daily-half hourly recoreds ( for one year )
and Ai is the column that contains all records in half hourly manner!


how to translate that to excel


plz help

[MickG]

Perhaps:-

Please Login or Register  to view this content.

[shalhoob]

WOOOOOW it works. thanks alot man you saved my life
many many thanks MickG
I appreciate your help and time.

cheers

[MickG]

Thanks for the feedback
Mick