Hi,
I have set up INDEX & MATCH formula for looking first non-blank cell.
But know i have a problem because i what to set up that formula will start looking from Right site not from the Left.
is this possible?
Thank you for help!
Example of formula now:
Please Login or Register to view this content.
Last edited by zeko90; 06-10-2015 at 03:15 AM.
hey dear your range is of only one column then how to get the nonblank from right??
jayajaya_4 : Sory wrong formula
Please Login or Register to view this content.
=LOOKUP(2,1/(A1:H1<>0),A1:H1)
=LOOKUP(2,1/(A1:H1<>""),A1:H1)
try this
Last edited by jayajaya_4; 06-10-2015 at 03:09 AM.
Works PerfectThank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks