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.
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.
This wont return the column letter, but it should return the heading...
=INDEX($a$1:$d$1,MATCH(0,a2:d2,-1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try in E2:
Please Login or Register to view this content.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks