Find first non-zero value in the result from an array formula
Author Message
Find first non-zero value in the result from an array formula

I have a table of repeating columns:

I am using a array formula

to pull out all the values under say Heading3 which gives me:

{0,0,0,0,0,0,0,0,0,0,0,26,0,0,0,0,0,56,0,0.....}

(the first three values from Heading3 are zero in this example...)

Now this was fine when I wanted to sum all the values under Heading3 in
order to test whether the row needed processing.

But now I find that I need to pull out the first non-zero value from the

Is it possible to pull out the required value from the array of values like
the one above???

OR is there another way that I have missed????

DG

Thu, 07 Jul 2005 19:59:26 GMT
Find first non-zero value in the result from an array formula
Let A2:I3 houses the following sample...

where "" stands for an empty cell.

If I'm understanding the task as intended, you could use to get the total

"[T]o pull out the first non-zero value from the values under Heading3",
use...

which is normally entered.

Quote:
> I have a table of repeating columns:

> I am using a array formula

> to pull out all the values under say Heading3 which gives me:

> {0,0,0,0,0,0,0,0,0,0,0,26,0,0,0,0,0,56,0,0.....}

> (the first three values from Heading3 are zero in this example...)

> Now this was fine when I wanted to sum all the values under Heading3 in
> order to test whether the row needed processing.

> But now I find that I need to pull out the first non-zero value from the

> Is it possible to pull out the required value from the array of values
like
> the one above???

> OR is there another way that I have missed????