Gap check formula?
Iam using Excel 2003. I have 2 col of a couple thousand rows and need to
determine where a gap in numbers exist between the rows Example:
a b
1 1 5
2 6 15
3 19 25
I recall using something similiar to =if(b1+1=a2 "no gap" "gap") but cannot
get it to work. Suggestions? Thank you
|