A very useful suggestion; however, still cant ID where the gaps are.

"JLatham" wrote:

Max has identified the probable problem (lack of commas in your formula).
I'm just wondering if this variation might make things more visible since
you'd only see where gaps are and not be distracted by many "no gap" entries:
=IF(B1+1=A2,"","gap")


"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