Return first non-zero value.

[George Lob]

I need to know how to return the first non-zero value in a row.

A B C D
1 0 0 5

in D I would like to have a formula like =10/<formula that would return 5>.

Any help would be appreciated.

 

[Peo Sjoblom]

=INDEX(A1:C1,MATCH(TRUE,A1:C1<>0,0))

entered with ctrl + shift & enter

 

[George Lob]

Thank you very much for your help.

=INDEX(A1:C1,MATCH(TRUE,A1:C1<>0,0))

entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

 

[George Lob]

Can you enter an array formula within a non-array formula? This is what I
want to accomplish, but I get an error:

=CHOOSE(MONTH(TODAY()),$C478,$E478,$G478,$I478,$K478,$M478,$O478,$Q478,$S478
,$U478,$W478,$Y478)-INDEX(B479:Z479,MATCH(TRUE,B479:Z479<>0,0))

Thanks for your help.

 

[George Lob]

Can you enter an array formula within a non-array formula. What I need to
accomplish is this, but I get an error:

=CHOOSE(MONTH(TODAY()),$C478,$E478,$G478,$I478,$K478,$M478,$O478,$Q478,$S478
,$U478,$W478,$Y478)-INDEX(B479:Z479,MATCH(TRUE,B479:Z479<>0,0))

 

[Peo Sjoblom]

Yes you can but by looking at your formula it is hard to see the logic,
you want to subtract the result from the index formula from the choose
formula?
In any case you need to array enter any formula that includes an array
formula

 

[George Lob]

I am trying to get a percentage based on the first value entered (which
could have been done in any month, with prior months being 0) and the
current month value. Anyway, thanks for your help!