how can I find the first non-zero cell
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
|