select the most recent value from one block of 10 columns

AmandaSS

Board Regular
Joined
Jan 7, 2014
Messages
133
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
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
Do you have a formula in those cells?
If so what is the formula
 

AmandaSS

Board Regular
Joined
Jan 7, 2014
Messages
133
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
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
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
Joined
Jan 7, 2014
Messages
133
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
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
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
Joined
Jan 7, 2014
Messages
133
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!
(y)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,078,275
Messages
5,339,204
Members
399,287
Latest member
ossa

Some videos you may like

This Week's Hot Topics

Top