View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.