Getting max/min values in wave data

[TOKYOJ1]

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

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>

 

[TOKYOJ1]

I'm still working on it...will let u know when I succeed

 

[sandy666]

sure, let me know if you need movie about it