LinkBack URL
About LinkBacks
Hi,
I have row list that some has blanks. I want to have a formula that will copy the last non black cell in each row
Hi,
I have row list that some has blanks. I want to have a formula that will copy the last non black cell in each row
Last edited by Elainefish; 11-23-2015 at 03:57 PM.
pls attach a sample excel file with expected result
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Try:
=LOOKUP(2,1/(A2:A30<>""),A2:A30)
assuming that the range of cells is A2 to A30.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
hi. i had issues uploading my file a while ago.... but now my question with file is posted. hope you can help me. thanks in adv
Originally Posted by Glenn Kennedy
hi. i had issues uploading my file a while ago.... but now my question with file is posted. its not exactly how i wanted it. hope you can help me. thanks in adv
In F2,
=LOOKUP(9E+307, A2:E2/(A2:E2<>""))
Entia non sunt multiplicanda sine necessitate
this solves my problem. but I am wondering why 307 in formula?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks