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

1. ## Re: select the most recent value from one block of 10 columns

Originally Posted by AmandaSS
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).

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

3. ## Re: select the most recent value from one block of 10 columns

Originally Posted by Fluff
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))

4. ## 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?

5. ## Re: select the most recent value from one block of 10 columns

Originally Posted by Fluff
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

6. ## 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

7. ## Re: select the most recent value from one block of 10 columns

Originally Posted by Fluff
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. ## Re: select the most recent value from one block of 10 columns

You're welcome & thanks for the feedback