View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VCUE VCUE is offline
external usenet poster
 
Posts: 4
Default First Positive in Horizontal Array

How do I obtain the result/value of the first positive/nonzero value in a one
row horizontal array?
If I have:
A B C D E F
0 3 2 3 0 3
What function looks and retreives the value "3" from first row in column B
Thanks