Loop problem

[pushkinpassey]

Hello,
I think this a quite trivial for most of you, but I have searched and looked at a fair number of loop examples to try and solve my problem, but I can't get my head round it.

Basically, my source data is given in hours (so 8760 rows of data) and the columns are different elements. I need to find the minimum value of the 2nd column, 22nd column, 32nd, 42nd, 52nd, and so on and write them on a separate sheet together.

Currently, I have managed to write this:

Please Login or Register  to view this content.

Unfortunately, this formula is putting the min of column 22 in all 3 cells in Sheet2.

I have also attached a file for your reference.
Min.xlsm

How can I correct this loop?

Thanks!
Pushkin

[mike7952]

Im not sure exactly what your wanting see if this helps.

Please Login or Register  to view this content.

[TMS]

See if this works for you:

Please Login or Register  to view this content.

Regards, TMS