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

Thread: select the most recent value from one block of 10 columns
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Jan 2014
    Location
    Amsterdam
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: select the most recent value from one block of 10 columns

    Quote Originally Posted by AmandaSS View Post
    thanks for your feedbacks, James006 and Fluff, but i still dont understand why it does not work..

    here a print screen of what i have done.

    thanks,
    Amanda


    PS: unfortunately the web site does not allow to insert pic from a desktop directory
    PS: the formula works on a separated spread sheet and for the example i had made, but not for spread sheet i am using for my analysis.....
    Once i implement the Worksheet Formulas i get the figures that are relative to 2019. In all other cases (for those companies whose most recent value is before 2019) i dont get any result (the cell is blank).
    Last edited by AmandaSS; Aug 29th, 2019 at 06:58 AM. Reason: to carify better...

  2. #12
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,218
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: select the most recent value from one block of 10 columns

    Do you have a formula in those cells?
    If so what is the formula
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #13
    Board Regular
    Join Date
    Jan 2014
    Location
    Amsterdam
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: select the most recent value from one block of 10 columns

    Quote Originally Posted by Fluff View Post
    Do you have a formula in those cells?
    If so what is the formula
    yes, i do have a formula in those cells, and it is the same as for the cell i get the result for 2019....
    i tried to fix the problem by formatting the data (format cells/number). I also copied the all table in a new spread sheet. This all didint work so far.

    PS: the formula i used is =INDEX(B4:K4,MATCH(TRUE,INDEX((B4:K4<>""),0),0))
    Last edited by AmandaSS; Aug 29th, 2019 at 08:43 AM.

  4. #14
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,218
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: select the most recent value from one block of 10 columns

    Sorry, I obviously wasn't very clear.
    using my example in post#8, do you have formulae in the cells B2:K4?
    If so what is that formula?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #15
    Board Regular
    Join Date
    Jan 2014
    Location
    Amsterdam
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: select the most recent value from one block of 10 columns

    Quote Originally Posted by Fluff View Post
    Sorry, I obviously wasn't very clear.
    using my example in post#8, do you have formulae in the cells B2:K4?
    If so what is that formula?
    Sorry, I hadn't understood well. No, in cells B2:K4 I don't have formula, I just have numbers
    Last edited by AmandaSS; Aug 29th, 2019 at 10:29 AM.

  6. #16
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,218
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: select the most recent value from one block of 10 columns

    Ok, double check that you don't have anything in the "Blank" cells.
    Try selecting a blank cell & press the Delete button
    Last edited by Fluff; Aug 29th, 2019 at 10:33 AM.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  7. #17
    Board Regular
    Join Date
    Jan 2014
    Location
    Amsterdam
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: select the most recent value from one block of 10 columns

    Quote Originally Posted by Fluff View Post
    Ok, double check that you don't have anything in the "Blank" cells.
    Try selecting a blank cell & press the Delete button
    SOLVED!
    in each empty cell there was a space, that's why the formula was not working....crazy!

    but really thanks a lot for holding on with this thread!

  8. #18
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,218
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: select the most recent value from one block of 10 columns

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

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
  •