Return Column Letter based on condition

Hi Forum,

I have been trying to find a forumla-only way (unable to make use of VBA due to policy) to return the column letter based on last cell that is not blank.

Example:
Example.PNG


Appreciate any help that may be provided.

Cheers.

Originally Posted by FDibbins

This wont return the column letter, but it should return the heading...
=INDEX($a$1:$d$1,MATCH(0,a2:d2,-1))

Thank you so much! This workaround is perfect.

I had something similiar but only after looking at your solution have I realised I had been Indexing incorrectly. Anyhow, once again thank you.

Originally Posted by bebo021999

Try in E2:

Please Login or Register  to view this content.

WOW! This is great as well, thanks for the input.

Just quickly, would be able to explain how this works by any chance?

Originally Posted by bebo021999

LOOKUP found last date and returned column index

ADDRESS returned address, likes "D1"

SUBTITUTE returns "D"

=SUBSTITUTE(ADDRESS(1,LOOKUP(10^6,$A2:$D2,COLUMN($A2:$D2)),4),1,"")

Thank you very much for doing that. Cheers.