First Positive in Horizontal Array

[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

 

[T. Valko]

See your other post

 

[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