Thanks:  0
Likes:  0

1. 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

2. 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
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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•