This seems to work though I don't get some values that your sample shows:
Enter the formula in D3 and fill down.
Formula:
=IF(B3<=MAX($B$2:$B$45),IF(B3-B2>=2,B3,IF(B3-B2<=-2,B3,"")))
|
A |
B |
C |
D |
1 |
Time |
Raw data values |
Prefered data |
My Data |
2 |
0 |
0 |
0 |
0 |
3 |
1 |
1 |
|
|
4 |
2 |
0 |
|
|
5 |
3 |
2 |
2 |
2 |
6 |
4 |
1 |
|
|
7 |
5 |
2 |
|
|
8 |
6 |
3 |
|
|
9 |
7 |
2 |
|
|
10 |
8 |
4 |
4 |
4 |
11 |
9 |
5 |
|
|
12 |
10 |
4 |
|
|
13 |
11 |
7 |
7 |
7 |
14 |
12 |
6 |
|
|
15 |
13 |
8 |
|
8 |
16 |
14 |
7 |
|
|
17 |
15 |
8 |
|
|
18 |
16 |
9 |
9 |
|
19 |
17 |
10 |
|
|
20 |
18 |
11 |
11 |
|
21 |
19 |
10 |
|
|
22 |
20 |
12 |
|
12 |
23 |
21 |
13 |
13 |
|
24 |
22 |
15 |
15 |
15 |
25 |
23 |
16 |
|
|
26 |
24 |
18 |
18 |
18 |
27 |
25 |
19 |
|
|
28 |
26 |
20 |
20 |
|
29 |
27 |
19 |
|
|
30 |
28 |
19 |
|
|
31 |
29 |
18 |
18 |
|
32 |
30 |
17 |
|
|
33 |
31 |
16 |
16 |
|
34 |
32 |
15 |
|
|
35 |
33 |
13 |
13 |
13 |
36 |
34 |
12 |
|
|
37 |
35 |
10 |
10 |
10 |
38 |
36 |
8 |
8 |
8 |
39 |
37 |
7 |
|
|
40 |
38 |
6 |
6 |
|
41 |
39 |
4 |
4 |
4 |
42 |
40 |
3 |
|
|
43 |
41 |
2 |
2 |
|
44 |
42 |
1 |
|
|
45 |
43 |
0 |
0 |
|
Bookmarks