Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Help requested with formula
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Apr 2006
    Posts
    269
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help requested with formula

    Hi Marcelo and Sparky

    Thank you very much for your help - Marcelo had interpreted my post correctly (even though it wasn't very clear) but I had made the schoolboy error of pasting the formula into cell AI2284 without updating the row number in the formula (so it was searching the contents of I2). I realised as soon as Marcelo explained wha tthe formula was doing. All working great now.

    you have both been very helpful and generous with your time - much appreciated!

    Rich

  2. #12
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,272
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Help requested with formula

    You're very welcome. Glad we've helped.

    M.

  3. #13
    Board Regular
    Join Date
    Feb 2013
    Posts
    151
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help requested with formula

    It's always nice to find a solution.
    I've been helped in this forum so many times I try to help others if I can.
    At first I was reluctant as I'm nowhere near the level of guys like Marcelo.
    Then I realised there are folk out there looking for help just like I was at the beginning.
    Even someone quite experienced at Excel can learn something from a relative newbie.
    It's such a vast application with so many possibilities. Nobody knows everything.
    I regularly take a look at zero reply posts to see if there's anything I can help with.

Some videos you may like

User Tag List

Tags for this Thread

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
  •