xeven_
Active Member
- Joined
- Jan 20, 2012
- Messages
- 302
I have % data in column F. I want to calculate only the consecutive positive or negative days adjacently in column G as shown in the illustration, Is there a formula I can enter as I have to go back quite a number of years/days and this is very time consuming doing it manually.
Thanks in advance.
<colgroup><col width="67" style="width:51pt"> <col width="67" style="width:51pt"> <col width="67" style="width:51pt"> </colgroup><tbody>
</tbody>
Thanks in advance.
45 | 1.00% | 1.02% |
45 | -0.46% | |
45 | 0.38% | |
45 | -0.02% | |
45 | 0.02% | |
46 | 0.99% | |
46 | 1.16% | |
46 | 0.09% | |
47 | 0.47% | 2.73% |
47 | -0.04% | |
47 | 0.94% | |
47 | 0.13% | 1.07% |
45 | -4.39% | |
45 | -0.31% | |
45 | -0.69% | |
44 | -0.90% | |
44 | -0.48% | |
44 | 0.05% | |
44 | 0.50% | 0.55% |
<colgroup><col width="67" style="width:51pt"> <col width="67" style="width:51pt"> <col width="67" style="width:51pt"> </colgroup><tbody>
</tbody>