Hello everyone-- I know that title probably made no sense, but I am hoping the presence of an actual table will help you gurus see what I am looking to do.
Within a worksheet, I have a series of values (column a) for which I would like to return the current minimum value. Further more, the ranges for which I am interested in finding minimum values are defined by the presence of a 1 value (column b). In column c, I would like to be able to return the same values as the formula i have inputted, but I would like to do this automatically as my data set is very large.
A -------------B----------------------- C
<tbody>
</tbody>
As you can see, I need to open and fix the range at the first presence of the 1 value and close it on the final 1 value. I am familiar with VBA and some rudimentary uses, but is there any way you folks can help me in the right direction?
Thanks so much,
KJ
Within a worksheet, I have a series of values (column a) for which I would like to return the current minimum value. Further more, the ranges for which I am interested in finding minimum values are defined by the presence of a 1 value (column b). In column c, I would like to be able to return the same values as the formula i have inputted, but I would like to do this automatically as my data set is very large.
A -------------B----------------------- C
10 | 0 | 0 |
9 | 1 | =min(a$2$:a2) |
9 | 1 | =min(a$2$:a3) |
8 | 1 | =min(a$2$:a4) |
9 | 1 | =min(a$2$:a5) |
8 | 1 | =min(a$2$:a6) |
7 | 0 | 0 |
7 | 0 | 0 |
7 | 1 | 0 |
8 | 1 | =min(a$10$:a10) |
9 | 1 | =min(a$10$:a11) |
10 | 0 | 0 |
9 | 1 | =min(a$13$:a13) |
7 | 1 | =min(a$13:a14) |
7 | 1 | =min(a$13$:a15) |
<tbody>
</tbody>
As you can see, I need to open and fix the range at the first presence of the 1 value and close it on the final 1 value. I am familiar with VBA and some rudimentary uses, but is there any way you folks can help me in the right direction?
Thanks so much,
KJ