First Positive in Horizontal Array

V

VCUE

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
 
D

Dave Peterson

Check your other post.
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
Click to expand...
 
Top