how can I find the first non-zero cell

  • Thread starter Thread starter rebecca
  • Start date Start date
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
 
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.
 
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
 
Back
Top