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
Bookmarks