S
snappertime
I want to find the number in a column that is closest to 0 (number may be
positive or negative) and return a number in an adjacent cell, if no number
in the adjacent cell I want the next number that is closest to 0 that does
have a number in the adjacent cell.
eg.
o/s ch
16.337
-2.318
-5.013 34.352
2.158
12.358
11.514
-22.643
-1.186
17.193
-18.996
27.852 110.781
-31.614 127.861
25.418
I want 34.352 to be displayed
positive or negative) and return a number in an adjacent cell, if no number
in the adjacent cell I want the next number that is closest to 0 that does
have a number in the adjacent cell.
eg.
o/s ch
16.337
-2.318
-5.013 34.352
2.158
12.358
11.514
-22.643
-1.186
17.193
-18.996
27.852 110.781
-31.614 127.861
25.418
I want 34.352 to be displayed