Hi,
I have a set of data that is in wave format going from positive and negative numbers and positive numbers again.... (which I have marked "X")
How do I get excel to identify these points between highest positives and lowest negatives?
https://www.dropbox.com/sh/2bms6secmr3b8oc/AABPQl-EIuP8l0ZzvrnrYLT9a?dl=0
Thanks in advance
TJ
<tbody>
</tbody>
I have a set of data that is in wave format going from positive and negative numbers and positive numbers again.... (which I have marked "X")
How do I get excel to identify these points between highest positives and lowest negatives?
https://www.dropbox.com/sh/2bms6secmr3b8oc/AABPQl-EIuP8l0ZzvrnrYLT9a?dl=0
Thanks in advance
TJ
3/4/1925 12:00 | 3.01 | |
4/4/1925 12:00 | 3.09 | |
5/4/1925 12:00 | 3.14 | |
6/4/1925 12:00 | 3.18 | |
7/4/1925 12:00 | 3.19 | X |
8/4/1925 12:00 | 3.18 | |
9/4/1925 12:00 | 3.15 | |
10/4/1925 12:00 | 3.08 | |
11/4/1925 12:00 | 3 | |
12/4/1925 12:00 | 2.89 | |
13/4/1925 12:00 | 2.75 | |
14/4/1925 12:00 | 2.59 | |
15/4/1925 12:00 | 2.41 | |
16/4/1925 12:00 | 2.2 | |
17/4/1925 12:00 | 1.98 | |
18/4/1925 12:00 | 1.74 | |
19/4/1925 12:00 | 1.48 | |
20/4/1925 12:00 | 1.21 | |
21/4/1925 12:00 | 0.94 | |
22/4/1925 12:00 | 0.66 | |
23/4/1925 12:00 | 0.37 | |
24/4/1925 12:00 | 0.09 | |
25/4/1925 12:00 | -0.19 | |
26/4/1925 12:00 | -0.47 | |
27/4/1925 12:00 | -0.73 | |
28/4/1925 12:00 | -0.99 | |
29/4/1925 12:00 | -1.24 | |
30/4/1925 12:00 | -1.48 | |
1/5/1925 12:00 | -1.7 | |
2/5/1925 12:00 | -1.91 | |
3/5/1925 12:00 | -2.1 | |
4/5/1925 12:00 | -2.28 | |
5/5/1925 12:00 | -2.45 | |
6/5/1925 12:00 | -2.6 | |
7/5/1925 12:00 | -2.74 | |
8/5/1925 12:00 | -2.86 | |
9/5/1925 12:00 | -2.96 | |
10/5/1925 12:00 | -3.06 | |
11/5/1925 12:00 | -3.13 | |
12/5/1925 12:00 | -3.2 | |
13/5/1925 12:00 | -3.25 | |
14/5/1925 12:00 | -3.29 | |
15/5/1925 12:00 | -3.31 | |
16/5/1925 12:00 | -3.32 | X |
17/5/1925 12:00 | -3.32 | X |
18/5/1925 12:00 | -3.31 |
<tbody>
</tbody>