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:
Formula:![]()
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
Bookmarks