Link to home
Start Free TrialLog in
Avatar of Andreas Hermle
Andreas HermleFlag for Germany

asked on

how to mark numbers were sequential numbering is interrupted

Dear Experts:

I got thousands of figures in Column A of the current worksheet. They are sorted and have the following make-up:

90-001
90-002
90-003
90-005
90-007
90-009
90-020
90-021
90-022
90-025
.....
90-437

Is it possible by means of a formula or conditional formatting to show the ones where the sequence of '1' is not maintained,

Help is much appreciated. Thank you very much in advance.

I have attached a sample file for your convenience.

Regards, Andreas
sequential_numbering.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Realised that don't actually need to enclose in the VALUE function:

=RIGHT(A2,3)<>RIGHT(A1,3)+1
Avatar of Andreas Hermle

ASKER

Both codes work just fine. Thank you very much for your great help. I really appreciate it. Regards, Andreas