Hey All,
Been working on this for a while and couldn't figure it out, tried offset, and Match/INDEX. I still cant get around the issue of the range not being a consistent nth row.
<tbody>
</tbody>
As the above table illustrates the range does not hold a pattern of every nth row.I need to create a moving "anchor" to say "from each 100% find min until the next 100%.
Thanks!
Been working on this for a while and couldn't figure it out, tried offset, and Match/INDEX. I still cant get around the issue of the range not being a consistent nth row.
10:00 | 100% |
10:01 | 95% |
10:02 | 100% |
10:03 | 95% |
10:04 | 92% |
<tbody>
</tbody>
As the above table illustrates the range does not hold a pattern of every nth row.I need to create a moving "anchor" to say "from each 100% find min until the next 100%.
Thanks!