Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Dec 2000
    Location
    Temple, Texas, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert cell fouls formula (2003 (11.56.12.5606))

    I know this is probably under "so easy a toddler could do it", but it's been a long week. I'm trying to help a colleague who gets data to fix, and the easiest way to do it is import into Excel and move it around. She has data in column A & B, then created a formula in column C to help her find the clunkers, for example, =IF(A5=B5, "OK", "NO"). She sees a NO in C5, and she can fix it by inserting a blank cell at B5, moving it to C6. But, the formula in C6 changes to =IF(A6=B7, "OK", "NO"). I've tried using absolute and mixed cell references, and the INDIRECT and OFFSET functions, but I'm just spinning my wheels. Any help would be appreciated!
    Jim Whitt
    Pharmacist
    Temple, Texas

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert cell fouls formula (2003 (11.56.12.5606))

    You could use this formula in C2:

    =IF(OFFSET(C2,0,-2)=OFFSET(C2,0,-1), "OK", "NO")

    and fill down as far as needed.

  3. #3
    Star Lounger
    Join Date
    Dec 2000
    Location
    Temple, Texas, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert cell fouls formula (2003 (11.56.12.5606

    It works great. I knew I was close, but just hadn't put the pieces together. Thanks a million, and have a great weekend!
    Jim Whitt
    Pharmacist
    Temple, Texas

  4. #4
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert cell fouls formula (2003 (11.56.12.5606

    Jim, just a little point so your chum has less typing:
    if she replaces
    =IF(A5=B5, "OK", "NO")
    with this
    =A5=B5 and copies down, then she'll get the answers TRUE or FALSE
    This might save a few milliseconds in her busy day!

  5. #5
    Star Lounger
    Join Date
    Dec 2000
    Location
    Temple, Texas, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert cell fouls formula (2003 (11.56.12.5606

    Thanks very much, John!
    Jim Whitt
    Pharmacist
    Temple, Texas

Posting Permissions

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