Latest non blank cell value

Hi,

I have a case, when I have a range of months which has its own coreposning amount.

for example year 2012, which has its 12 months spread horizontally and each month has its value, home months, are missing amount for example there is aamount in january or february, but not in other months, I need to extract from this rows the latest non blank cell. not the last cell and not the first one, but the latest no blank cell.

for example one row has amount in January and March, and another in february and august, I need the latest amount from each one, in first case from AMrch and in second case from August.

please help, if needed I will upload a sample file..

By all means, upload a sample sheet.
But maybe this site offers the wanted solution?

..please help, if needed I will upload a sample file..

It will be useful. Specially to see how your data looks like..

1. Have you opened the link I provided?
2. Forum rules suggest you wait about 24 hr before bumping

hi G.Bregvadze, try this in Q4:
=LOOKUP(2,1/(E4:P4<>0),E4:P4)

Originally Posted by benishiryo

hi G.Bregvadze, try this in Q4:
=LOOKUP(2,1/(E4:P4<>0),E4:P4)

Interesting, can you do some explain.Thank you.
=LOOKUP(2,1/(E4:P4<>0),E4:P4) --> why is 2?
=LOOKUP(2,1/(E4:P4<>0),E4:P4) --> <> meaning?
=LOOKUP(2,1/(E4:P4<>0),E4:P4) --> how to divide?

There is an explanation at this site - Good luck