View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nigel Toates[_2_] Nigel Toates[_2_] is offline
external usenet poster
 
Posts: 2
Default lowest number in a row that is greater than zero

I have a row of 19 cells that have many zeros in it but I need to find the
lowest value that is greater than "0"

The problem comes from having 19 months of sales figures and I want to find
the lowest month value we had sales in.

Thanks Nigel