detect number of exact successive cells

[mmatta]

Hi all,

I have a table with start and end times of events which i filter based on several criteria with a 1 or a 0. The filters are dependent on adjacent events events so if I have consecutive filters I want the output to reference/recognize that there are 3 rows filtered in the first cell. Something like this:

ID Filter NumSuccessive
1 1 4
2 1
3 1
4 1
5
6 1 2
7 1
8
9 1 1
10
11
12 1 3
13 1
14 1


Can someone please help - I can't think of a clean way to do this with formulas.

Thanks

[rylo]

Hi

If your data is in the range A1:B15 (ie row 1 has headings), then
C2: =IF(AND(B2<>"",B2<>B3),COUNT($B$2:B2)-SUM($C$1:C1),"")

HTH

rylo