| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Horizontal array | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| How do I paste horizontal references in large array | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Linear Mode
