search for first value greater than zero in a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=INDEX(J3:U3,1,MATCH(TRUE,J3:U3>0,0))

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

HTH
 
Back
Top