Find Last Non-Blank Cell in Row and Corresponding Date Value

[dwking1989]

Hi,

I'm working with the World Development Indicators dataset which has a large amount of missing values for countries where data availability is poor.

I'm currently using =LOOKUP(2,1/(E5:BM5<>""),E5:BM5) to find the last non-blank value in the row and then =INDEX(FILTER($E$4:$BM$4,E5:BM5<>""),1) to find the corresponding date which I found on another thread.

However, this second formula gives me the first non-blank value date as opposed to the last. I was wondering if there was an easy fix to this to get the corresponding date for the last non-blank cell.

Thanks,

David

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LOOKUP(2,1/(E5:BM5<>""),E$4:BM$4)

 

[dwking1989]

Perfect, thanks for your help!

 

[Fluff]

You're welcome & thanks for the feedback.