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

Gap check formula?
 

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

Gap check formula?
 

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

Gap check formula?
 

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

Gap check formula?
 

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

Gap check formula?
 

For the sample data that you posted, indicate the expected results in col C
,
and the "wrong" results you got when you used Jerry's formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LSSR" wrote in message
...
A very useful suggestion; however, still cant ID where the gaps are.

Gap check formula?
 

Got it to work. thank you both

"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

Gap check formula?
 

good to hear that. admit i'm bemused what happened over there the first time
round
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LSSR" wrote in message
...

Got it to work. thank you both