Continuity check

[skbiswas]

I have a table like this

[pre]

A1    ID     B1   Start   C1   End
A2     1     B2     0     C2     5
A3     1     B3     3     C3    10
A4     2     B4     0     C4    20
A5     2     B5    20     C5    25
A6     2     B6    25     C6    40
A6     3     B6     0     C6    5O

[/pre]
the table contains more than 100000 rows. It looks that Line having ID 1 should be from 0 to 10. It has two segment 0-5 and 5-10. But in the second part in table it is 3-10. I need to find these rows having wrong point. Other ID in the above table (ID 2 and 3 are ok coz they are continuous. I ID 2 they are 0-20 and 20-25 and 25-40.Thanks in advance. Plz help if any one have any idea

 

[NARAYANK991]

Hi Biswas ,


I am not sure whether your IDs are in sorted order , but if they are the way your small sample shows , then try this formula in D2 :


=IF(A2=A1,IF(B2=C1,"","Discontinuity"),IF(B2<>0,"Wrong Start",""))


Copy this down.


Narayan

 

[skbiswas]

hi NARAYAN

Thanks a lot. Yes it works