View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H[_4_] Mike H[_4_] is offline
external usenet poster
 
Posts: 19
Default 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