Thank you for the reply. I tried it but it does not detect the gaps. Any
other formula would be welcomed.

"Max" wrote:

Perhaps you meant this
In C1, copied down: =IF(B1+1=A2,"no gap","gap")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LSSR" wrote:
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