to sinalize not sequential number

[Guest]

Hi!

In cloumn I would like to sinalize not sequential number.
Ex:
A B
1
2
3
4
6 Oops!

Is it possible in Excel 2007, please?

Thanks in advance.
an

 

[Peo Sjoblom]

Excuse me if I am ignorant but does "sinalize" means?

 

[Gord Dibben]

Not sure what "sinalize" means but maybe enter in B2 and copy down.

=IF(AND(A2<>"",(A2<>A1+1)),"oops","")

You must have a number in A1


Gord Dibben MS Excel MVP

 

[Guest]

Sorry for my error "to signalize"...

Thank you for your help.

Work very fine.
an