Col.H | Col. L | Col. O | Date: | 14.09.2018 |
Date | Length | Cum. Length / Result | ||
21.08.2018 | 4 | 4 | ||
25.10.2018 | 6 | 6 | ||
06.11.2018 | 8 | 14 | ||
29.11.2018 | 5 | 19 | ||
17.07.2018 | 9 | 13 | ||
01.08.2018 | 7 | 20 | ||
09.08.2018 | 12 | 32 | ||
22.08.2018 | 22 | 54 |
<tbody>
</tbody>
Hey guys,
I need some help with a tricky problem and I have no clue how to solve it. Basically what I want is to accumulate the data with a constraint. So..
In Col. O are the results. Don't know if it's possible withou VBA?!
Every date that is before/equal 14.09.2018 should be accumulated (here the accum. dates are: 21.08.2018, 17.07.2018, 01.08.2018, 09.08.2018 and 22.08.2018).
And the other ones should be accumulated as well.
Thank you for your help.
With best regards
Joe