• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

To find last visible text in Highlighted Column

shrivallabha

Excel Ninja
You can use an IF construct like below which is simple but lengthy.
=IF(K3<>"",K3,IF(H3<>"",H3,IF(F3<>"",F3,IF(D3<>"",D3,IF(B3<>"",B3,"")))))

If rest of the cells are always blank then you can also use which will be easier to extend if you have more columns:
=IFERROR(LOOKUP(2,1/(B3:K3<>""),B3:K3),"")
 

bosco_yip

Excel Ninja
If you want to avoid data in non highlighted column cells

Try,

=LOOKUP(1,0/(T(OFFSET(B3,,{0,2,4,6,9}))<>""),T(OFFSET(B3,,{0,2,4,6,9})))

Regards
 
Top