From left to right how can I get a formula that will find the answer to each
row as stated so the formula returns the first non-zero cell?

0 0 0 0 42.5 answer 42.5
0 0 0 4.74 0 answer 4.74
101.5 102 0 0 0 answer 101.5

99.975 101 0 0 85.188 answer 99.975
0 74.5 0 0 0 answer 74.5

Rebecca,
Try this array formula

=OFFSET(A1,0,MIN(IF(1:10,COLUMN(1:1)))-1,1,)

This is an array formula which must be entered by pressing
CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly
brackets
'around the formula {}. You can't type these yourself. If you edit the
formula
'you must enter it again with CTRL+Shift+Enter.


Mike


On Mon, 19 Oct 2009 07:58:14 -0700, rebecca
wrote:

From left to right how can I get a formula that will find the answer to each
row as stated so the formula returns the first non-zero cell?

0 0 0 0 42.5 answer 42.5
0 0 0 4.74 0 answer 4.74
101.5 102 0 0 0 answer 101.5

99.975 101 0 0 85.188 answer 99.975
0 74.5 0 0 0 answer 74.5

Try this array* formula:

=INDEX(A2:C2,1,MATCH(TRUE,A2:C20,0))

*formula must be confirmed using Ctrl+Shift+Enter, not just Enter.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"rebecca" wrote:

From left to right how can I get a formula that will find the answer to each
row as stated so the formula returns the first non-zero cell?

0 0 0 0 42.5 answer 42.5
0 0 0 4.74 0 answer 4.74
101.5 102 0 0 0 answer 101.5

99.975 101 0 0 85.188 answer 99.975
0 74.5 0 0 0 answer 74.5

Array function

use Ctrl + shift + enter

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


On Oct 19, 7:58*pm, rebecca wrote:
From left to right how can I get a formula that will find the answer to each
row as stated so the formula returns the first non-zero cell?

0 * * * 0 * * * 0 * * * 0 * * * 42.5 * * * * *answer 42.5
0 * * * 0 * * * 0 * * * 4.74 * *0 * * * * * * * answer 4.74
101.5 * 102 * * 0 * * * 0 * * * 0 * * * * * * * answer 101.5

99.975 *101 * * 0 * * * 0 * * * 85.188 * * *answer 99.975
0 * * * 74.5 * *0 * * * 0 * * * 0 * * * * * * *answer 74.5

Hi Rebecca

Try the below formula in F1 and copy down as required..

=INDEX(A1:E1,MATCH(TRUE,INDEX(A1:E1<0,),))

If this post helps click Yes
---------------
Jacob Skaria


"rebecca" wrote:

From left to right how can I get a formula that will find the answer to each
row as stated so the formula returns the first non-zero cell?

0 0 0 0 42.5 answer 42.5
0 0 0 4.74 0 answer 4.74
101.5 102 0 0 0 answer 101.5

99.975 101 0 0 85.188 answer 99.975
0 74.5 0 0 0 answer 74.5