View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MPI Planner[_2_] MPI Planner[_2_] is offline
external usenet poster
 
Posts: 10
Default locate first value greater than

I would like to be able to return the first column that has a number greater
than zero. For instance

3/2 3/9 3/16 3/23 3/30
Product A 0 0 12 0 20

How could I get a result that either returned 3/16 as the first date or
column 4 as the first instance?