# select the most recent value from one block of 10 columns

#### AmandaSS

##### Board Regular
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:

#### Fluff

##### MrExcel MVP, Moderator
Do you have a formula in those cells?
If so what is the formula

#### AmandaSS

##### Board Regular
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:

#### Fluff

##### MrExcel MVP, Moderator
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?

#### AmandaSS

##### Board Regular
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:

#### Fluff

##### MrExcel MVP, Moderator
Ok, double check that you don't have anything in the "Blank" cells.
Try selecting a blank cell & press the Delete button

Last edited:

#### AmandaSS

##### Board Regular
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!

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback