Hello,
Need some help with the data below with dates and numbers changing from positive to negative and positive again.
At the point of change from positive to negative number, I would like to mark "X" and also from negative to positive number also mark "X" on third column.
Can anyone suggest a formula I can use for my spreadsheet?
Thanks in advance,
TJ
Date
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Need some help with the data below with dates and numbers changing from positive to negative and positive again.
At the point of change from positive to negative number, I would like to mark "X" and also from negative to positive number also mark "X" on third column.
Can anyone suggest a formula I can use for my spreadsheet?
Thanks in advance,
TJ
Date
13/1/1925 0:00 | 2.07 | |
14/1/1925 0:00 | 1.91 | |
15/1/1925 0:00 | 1.75 | |
16/1/1925 0:00 | 1.59 | |
17/1/1925 0:00 | 1.43 | |
18/1/1925 0:00 | 1.27 | |
19/1/1925 0:00 | 1.11 | |
20/1/1925 0:00 | 0.95 | |
21/1/1925 0:00 | 0.79 | |
22/1/1925 0:00 | 0.64 | |
23/1/1925 0:00 | 0.19 | |
24/1/1925 0:00 | 0.05 | |
25/1/1925 | -0.09 | X |
26/1/1925 0:00 | -0.23 | |
27/1/1925 0:00 | -0.36 | |
28/1/1925 0:00 | -0.49 | |
29/1/1925 0:00 | -0.7 | |
30/1/1925 0:00 | -0.54 | |
31/1/1925 0:00 | -0.36 | |
1/2/1925 0:00 | -0.18 | |
2/2/1925 | 0 | X |
3/2/1925 0:00 | 0.2 | |
4/2/1925 0:00 | 0.4 | |
5/2/1925 0:00 | 0.6 | |
6/2/1925 0:00 | 0.81 | |
7/2/1925 0:00 | 1.01 | |
8/2/1925 0:00 | 1.22 | |
9/2/1925 0:00 | 1.43 | |
10/2/1925 0:00 | 1.63 | |
11/2/1925 0:00 | 1.82 | |
12/2/1925 0:00 | 2.01 | |
13/2/1925 0:00 | 2.19 | |
14/2/1925 0:00 | 2.36 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>