sequence check

[CAAT]

hello

i want to test the sequence of invoices number.
the results should show where there is gap in the sequence.
for example:
INV1
INV2
INV4

RESULTS: Gap between INV2 and INV4

Please help

Thanks

 

[Asheesh]

Hi CAAT,

Does this help..

 

[Hui]

Assunmimg your data is in A2:A4
In B3: =IF(RIGHT(A3,LEN(A3)-3)+0<>RIGHT(A2,LEN(A2)-3)+1,"Error","Ok")
Copy down

 

[CAAT]

thanks guys