# Latest non blank cell value

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

2. ## Re: Latest non blank cell value

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

3. ## Re: Latest non blank cell value

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

4. ## Re: Latest non blank cell value

I attached file

111.xlsx

5. ## Re: Latest non blank cell value

Are there any suggestions?

6. ## Re: Latest non blank cell value

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

7. ## Re: Latest non blank cell value

Yes I opned it but As I mentioned im my first post I need the latest value, not the last value, the formulas which are provided in the web page, return the last non-blank cell in row range. for example only from December 2012.

9. ## Re: Latest non blank cell value

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

10. ## Re: Latest non blank cell value

Thank you so much, thanks a lot, the exact solution,

I tried many combinations of lookup and index and other widely spread functions, but the result was always the same I got only the last value of the array. But I needed the latest value from array. thanks again for help an support. thanks

11. ## Re: Latest non blank cell value

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?

12. ## Re: Latest non blank cell value

There is an explanation at this site - Good luck

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1