how can I find the first non-zero cell

R

rebecca

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
 
L

Luke M

Try this array* formula:

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

*formula must be confirmed using Ctrl+Shift+Enter, not just Enter.
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Zeros in a row until encounter first non-zero value 9
checking two different cells 1
Find/Replace Select Numbers in a Cell 3
Excel: Last non zero value in a row 4
If function across sheets prints value of cell 4
Vlookup and return sheet name also 2
Zero as a value 9
Last non-zero 5

Top