last value "greater than zero" in a range
On May 15, 11:47*am, "Bob Phillips" wrote:
=LOOKUP(2,1/(F70:AB700),F70:AB70)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"TSW632" wrote in message
...
Hi folks,
I have formulae in every other cell from F70:AB70. I'm looking for a
way to return the last value greater than zero contained in that
range. Can I do this without editing VBA?
Thanks for any assistance.
Troy- Hide quoted text -
- Show quoted text -
Awesome!!! They both work. Thanks Rick and Bob!
|