View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LSSR LSSR is offline
external usenet poster
 
Posts: 8
Default 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