search for first value greater than zero in a row

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?
 
A

Ardus Petus

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight MAX Cell Greater Than Zero 4
Conditional format lowest value greater than zero and copy formula 2
Return value greater than in LOOKUP 3
lowest number in a row that is greater than zero 4
Finding the MIN value, but greater than zero 2
Last Value Greater Than Zero 7
lookup a value "greater than" 0 2
Conditional Sum date range 2

Top