Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | 52.0 | 10 | 48.6 | 35.0 | |||
2 | 50.2 | 20 | |||||
3 | 48.6 | 30 | |||||
4 | 46.6 | 40 | o | ||||
5 | 45.1 | 50 | o | ||||
6 | 43.4 | 60 | o | ||||
7 | 41.7 | 70 | o | ||||
8 | 40.1 | 80 | o | ||||
9 | 37.3 | 90 | o | ||||
10 | 36.8 | 100 | o | ||||
11 | 35.0 | 110 | |||||
12 | 33.4 | 120 | |||||
13 | 31.6 | 130 | |||||
14 | 30.0 | 140 | |||||
15 | 28.4 | 150 | |||||
16 | 26.6 | 160 | |||||
17 | 25.0 | 170 | |||||
Sheet1 |
What is the formula for D1 and E1, which get the cell value of column A one row before and after, when cell in column C = "o", thanks for the help.