There have been similar problems posted, but none of the solutions have worked for me:
I have a column H3:H29752 representing True/False by 1 and 0; I would like to know the maximum consecutive run of 1s; in this sample it's 4 ... I would like to know how to set up frequency counts of 4,5,6,7...etc consecutive occurrences ... I could do this in either Excel 2000 or Excel 2013 -which I'm even less familiar with. A short sample from H3:H26 follows ... I have uploaded a sample worksheet called: Consecutive_sample.xls; thank you very much for any assistance!
0 H3
1
0
1
0
1
0
0
0
0
0
1
0
1
1
1
1
0
0
1
0
1
1
0
Bookmarks