ExcelBanter - First Positive in Horizontal Array

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - First Positive in Horizontal Array (https://www.excelbanter.com/excel-discussion-misc-queries/194237-first-positive-horizontal-array.html)

VCUE

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

T. Valko

First Positive in Horizontal Array

See your other post

--
Biff
Microsoft Excel MVP

"VCUE" wrote in message
...
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

Dave Peterson

First Positive in Horizontal Array

Check your other post.

VCUE wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 07:24 PM.