Find Consistency
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Find Consistency

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com