| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can someone check this formula please? | Excel Discussion (Misc queries) | |||
| Check box formula | Excel Discussion (Misc queries) | |||
| Check box and and formula | Excel Discussion (Misc queries) | |||
| How do I check a formula? | Excel Discussion (Misc queries) | |||
| How do I set up a formula with a check box? | Excel Discussion (Misc queries) | |||
Threaded Mode
