Is there a formula that identifies the first occurrence of a value that is either: A) <-499 or B) >499 in both columns a & b?
example 1
-----a-----------b
1--"120"-------"120"
2--"250"-------"250"
3-"-100"------"375"
4-"-250"------"500"
5-"-650"------"600"
6
7-"500"
example 2
-----a-----------b
1--"120"-------"120"
2--"250"-------"250"
3-"-100"------"375"
4-"-250"-------"0"
5-"-650"------"-300"
6
7-"-650"
Bookmarks