Find Consistency

Parra · Feb 22nd, 2002, 12:15 PM

I have a column with data starting with A01, then A02, A03, A04 and so on. However the info is not always consistent, it might jump from A05 to A09. I want to know if there is a formula that lets me know if the cell above has gotten bigger by 1.
example
A01
A02
A05, not consistent
A06

Thanks

IML · Feb 22nd, 2002, 01:07 PM

You could a formula such as
=IF(RIGHT(A2,2)-RIGHT(A1,2)>1,"not consistent","")

in say b2. Or use a similar formula for conidional formatting. I assume the format was A"zero"1. If it is only one number, you could use
=IF(RIGHT(A2)-RIGHT(A1)>1,"not consistent","")

good luck

Quote:

On 2002-02-22 11:15, Parra wrote:
I have a column with data starting with A01, then A02, A03, A04 and so on. However the info is not always consistent, it might jump from A05 to A09. I want to know if there is a formula that lets me know if the cell above has gotten bigger by 1.
example
A01
A02
A05, not consistent
A06

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 12:15 PM	#1
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	I have a column with data starting with A01, then A02, A03, A04 and so on. However the info is not always consistent, it might jump from A05 to A09. I want to know if there is a formula that lets me know if the cell above has gotten bigger by 1. example A01 A02 A05, not consistent A06 Thanks