View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruce
 
Posts: n/a
Default count cells since last non-zero value

I would like to know (count) the number of cells since the last non-zero value.

An example would be my data is in cells A1:A10 with A10 representing the
most recent value.
Data examople as follows for A1:A10 respectively;

2, 3, 2, 3, 0, 1, 4, 0, 0 ,0

In this example A7 has the most recent non-zero value.
In A11 I want to have a formula that tells me that its been 3 zero data
points since the last value (which is 4).

Rgds,

bruce