to sinalize not sequential number
 

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

to sinalize not sequential number
 

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


--

Regards,

Peo Sjoblom

"an" wrote in message
...
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

to sinalize not sequential number
 

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


On Sat, 22 Sep 2007 10:44:02 -0700, an wrote:

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

to sinalize not sequential number
 

Sorry for my error "to signalize"...

Thank you for your help.

Work very fine.
an

"Gord Dibben" wrote:

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


On Sat, 22 Sep 2007 10:44:02 -0700, an wrote:

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