RandomTandem
New Member
- Joined
- Jul 10, 2017
- Messages
- 17
If I have a list of dates (in chronological order) in Column A and a list of stock purchases or sales in column B. Is there a formula which will help me find the last date where the running total was equal to zero prior to a date I put in cell C1?
In the below example, If I put 13th Aug in cell C1, it would tell me 12th Aug but if I had 15th Aug in cell C1, it would put 14th Aug
<tbody>
</tbody>
I would normally use a helper column to achieve this but I cannot do it in this example.
Thank you.
In the below example, If I put 13th Aug in cell C1, it would tell me 12th Aug but if I had 15th Aug in cell C1, it would put 14th Aug
Date | Purchase/Sale Amount |
10th Aug | +5 |
11th Aug | +10 |
12th Aug | -15 |
13th Aug | +80 |
14th Aug | -80 |
15th Aug | 10 |
<tbody>
</tbody>
I would normally use a helper column to achieve this but I cannot do it in this example.
Thank you.