search for first value greater than zero in a row
 

I have columns headed Jan through Dec, J2:U2

Dollar values are in the rows below this row. The values are either $0 or
greater than $0.

What function would I use to have excel look at a given row, from left to
right, say, J3:U3 and tell me the first dollar value that is greater than $0?

--
Brevity is the soul of wit.

search for first value greater than zero in a row
 

=INDEX(J3:U3,1,MATCH(TRUE,J3:U30,0))

This is an array formula, to be validated by Ctrl+Shift+Enter, not just
Enter

HTH
--
AP

"Dave F" a écrit dans le message de news:
...
I have columns headed Jan through Dec, J2:U2

Dollar values are in the rows below this row. The values are either $0 or
greater than $0.

What function would I use to have excel look at a given row, from left to
right, say, J3:U3 and tell me the first dollar value that is greater than
$0?

--
Brevity is the soul of wit.

search for first value greater than zero in a row
 

=INDIRECT(CHAR(MIN(IF(J3:U30,COLUMN(J3:U3)))+64)& 3)



"Dave F" skrev:

I have columns headed Jan through Dec, J2:U2

Dollar values are in the rows below this row. The values are either $0 or
greater than $0.

What function would I use to have excel look at a given row, from left to
right, say, J3:U3 and tell me the first dollar value that is greater than $0?

--
Brevity is the soul of wit.