LinkBack URL
About LinkBacks
Thanks, Carim.Originally Posted by Carim
Hi,
Following should help
=LOOKUP(2,1/(E1:E1000<>0),E1:E1000)
I loooove this forum!!! Sometimes I learn things I didn't even know I wanted to know (if that makes sense).
Thanks, Carim.Hi,
Following should help
=LOOKUP(2,1/(E1:E1000<>0),E1:E1000)
I loooove this forum!!! Sometimes I learn things I didn't even know I wanted to know (if that makes sense
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks