Spreadsheet: 714537d1611262928-need-a-formula-to-get-the-frequency-of-consecutive-mode-values-sample-data-check-the-highlighted-area
Sheet: Pivot.Weekly Counts

Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | Grand Total | Weekly Consecutive Mode Count | Should be:
01_10914 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25000 |  | 1
201499202 |  |  | 5 |  | 56.45 | 51.45 | 5 |  | 5 |  | 5 |  |  | 5 |  | 5 | 15 | 5 |  | 5 |  | 5 |  |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 25 |  |  | 56.45 |  |  | 299.35 |  | 1
[PHONE] |  |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  |  | 2 |  |  |  |  |  | 2 |  | 2 |  |  | 2 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 1
[PHONE] |  |  |  | 51.45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77.17 |  | 1
[PHONE] |  |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  |  | 2 |  |  | 44 |  | 1
[PHONE] |  |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  |  | 10 |  | 10 |  | 35.72 |  | 10 |  | 10 |  |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  |  | 10 |  | 10 |  | 10 |  | 10 |  | 70 |  | 10 | 35 | 25 | 10 |  |  | 365.72 |  | 1
[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  |  | 1 |  |  | 5 |  | 1
[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | 275.72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77.17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 352.89 |  | 1
[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2051.71 |  |  |  |  |  |  |  |  |  |  |  |  |  | 51.44 |  |  |  |  |  | 2103.15 |  | 1
[PHONE] |  |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  |  | 2 |  | 2 |  | 2 | 25 | 2 |  | 2 |  |  | 2 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 |  | 1
[PHONE] |  |  |  | 544.78 |  |  |  |  |  |  |  |  |  | 69.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87.41 |  |  |  | 177.61 |  |  | 879.6999999999999 |  | 1
[PHONE] |  |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  |  | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 |  | 1
[PHONE] | 25 |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 135 |  | 1
[PHONE] |  |  | 20 |  | 20 |  | 20 |  | 20 | 51.45 | 20 | 51.45 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  |  | 20 | 51.45 | 20 |  | 20 |  | 20 |  | 20 |  |  | 20.01 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  |  | 20 |  |  | 594.3599999999999 |  | 1
[PHONE] |  |  |  |  |  |  |  |  |  | 111 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  | 236 |  | 1
[PHONE] |  |  |  |  | 415.84 | 583.55 | 209.19 |  |  |  | 144.67 |  |  |  |  | 616.87 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.99 |  |  |  | 1996.11 |  | 1
[PHONE] |  |  |  |  |  |  | 102.9 |  | 514.5 | 514.5 |  |  | 411.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1543.5 |  | 2
[PHONE] |  |  |  |  |  |  |  | 51.45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.45 |  | 1
[PHONE] |  |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  |  | 5 |  |  |  |  |  | 5 |  | 5 |  |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  |  | 5 |  | 5 |  | 5 |  | 5 | 25.72 | 5 |  | 5 |  |  | 5 |  |  | 125.72 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1