View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Find first value in range

I'm trying to do the following:
Offset(A15, ____, -5)

where _____ is a function that says look at the range (B3:B20) and
return a reference to the first value that is greater than zero. I'd
rather not create vba code behind it, but will if I have absolutely
have to. Is there any way to see what is the first value in a range
that is greater than o?