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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
First Positive on Horizontal Array 7
Copy and Paste Word 2010 0
Help with multi-level list 0
Transfer data between two tables 3
How to use Sumifs with vertically and horizontally criterias 1
XIRR Giving Negative Number on Positive Cash Flow Stream 11

Top