Spreadsheet: 763853d1642432732-find-some-with-consecutive-days-log-book-new-for-excel-forum-glenn
Sheet: LogBook

 |  |  |  |  |  |  |  |  |  |  | 3 | Consecutive days
 |  |  |  |  |  |  |  |  |  |  |  | Consecutive days Block No. | Block length | [NAME] | Offset Blocks | Result for block |  | MAX
183 | 2012-09-16 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
184 | 2012-09-17 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
185 | 2012-09-18 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
186 | 2012-09-19 00:00:00 |  |  |  |  |  |  |  |  |  | 5.2
187 | 2012-09-21 00:00:00 |  |  |  |  |  |  |  |  |  | 17
188 | 2012-09-23 00:00:00 |  |  |  |  |  |  |  |  |  | 4.2
189 | 2012-09-24 00:00:00 |  |  |  |  |  |  |  |  |  | 3.6
190 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  |  | 4.8
191 | 2012-09-26 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
192 | 2012-09-29 00:00:00 |  |  |  |  |  |  |  |  |  | 1
193 | 2012-09-30 00:00:00 |  |  |  |  |  |  |  |  |  | 3.1
194 | 2012-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
195 | 2012-10-02 00:00:00 |  |  |  |  |  |  |  |  |  | 5.8
196 | 2012-10-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2.2
197 | 2012-10-05 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
198 | 2012-10-06 00:00:00 |  |  |  |  |  |  |  |  |  | 10
199 | 2012-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | 20
200 | 2012-10-09 00:00:00 |  |  |  |  |  |  |  |  |  | 30
201 | 2012-10-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2.3
202 | 2012-10-14 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
 | 2012-11-16 00:00:00 |  |  |  |  |  |  |  |  |  | 6
 | 2012-11-18 00:00:00 |  |  |  |  |  |  |  |  |  | 5.5
 | 2012-11-24 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
 | 2012-11-27 00:00:00 |  |  |  |  |  |  |  |  |  | 2.6
 | 2012-11-28 00:00:00 |  |  |  |  |  |  |  |  |  | 2.2
 | 2012-11-29 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
 | 2012-12-02 00:00:00 |  |  |  |  |  |  |  |  |  | 1.8
 | 2012-12-06 00:00:00 |  |  |  |  |  |  |  |  |  | 4.1
 | 2012-12-07 00:00:00 |  |  |  |  |  |  |  |  |  | 0.6
 | 2012-12-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2
 | 2012-12-09 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
 | 2012-12-11 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
 | 2012-12-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2.6
 | 2012-12-13 00:00:00 |  |  |  |  |  |  |  |  |  | 1.9
 | 2012-12-16 00:00:00 |  |  |  |  |  |  |  |  |  | 0.8
 | 2012-12-17 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
 | 2012-12-18 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
 | 2012-12-19 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
 | 2012-12-20 00:00:00 |  |  |  |  |  |  |  |  |  | 4.2
 | 2012-12-23 00:00:00 |  |  |  |  |  |  |  |  |  | 5.9
 | 2012-12-24 00:00:00 |  |  |  |  |  |  |  |  |  | 4.1
 | 2012-12-25 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2013-01-07 00:00:00 |  |  |  |  |  |  |  |  |  | 1
 | 2013-01-07 00:00:00 |  |  |  |  |  |  |  |  |  | 2.5
 | 2013-01-11 00:00:00 |  |  |  |  |  |  |  |  |  | 2.7
 | 2013-01-12 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
 | 2013-01-12 00:00:00 |  |  |  |  |  |  |  |  |  | 6.9
 | 2013-01-13 00:00:00 |  |  |  |  |  |  |  |  |  | 6.8
 | 2013-01-13 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
 | 2013-01-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2.3
 | 2013-01-16 00:00:00 |  |  |  |  |  |  |  |  |  | 6
 | 2013-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | 0.9
 | 2013-01-19 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
 | 2013-01-21 00:00:00 |  |  |  |  |  |  |  |  |  | 1.7
 | 2013-01-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2.6
 | 2013-01-25 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2013-01-26 00:00:00 |  |  |  |  |  |  |  |  |  | 4.2
 | 2013-01-27 00:00:00 |  |  |  |  |  |  |  |  |  | 3.1
 | 2013-01-28 00:00:00 |  |  |  |  |  |  |  |  |  | 0.6
 | 2013-01-29 00:00:00 |  |  |  |  |  |  |  |  |  | 2.6
 | 2013-01-30 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2013-01-31 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2013-02-02 00:00:00 |  |  |  |  |  |  |  |  |  | 2.6
 | 2013-03-17 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2013-03-22 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2013-03-25 00:00:00 |  |  |  | 1.5 |  |  |  |  |  | 1.3
 | 2013-03-26 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2013-03-27 00:00:00 |  |  |  | 0.5 |  |  |  |  |  | 1.3
 | 2013-03-27 00:00:00 |  |  |  | 0.7 |  |  |  |  |  | 1.3
 | 2013-03-27 00:00:00 |  |  |  |  |  |  |  |  |  | 0.8
 | 2013-03-28 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2013-05-14 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
 | 2013-05-15 00:00:00 |  |  |  |  |  |  |  |  |  | 3.2
 | 2013-06-05 00:00:00 |  |  |  |  |  |  |  |  |  | 5.2
 | 2013-06-06 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
 | 2013-06-07 00:00:00 |  |  |  |  |  |  |  |  |  | 4.6
 | 2013-07-22 00:00:00 |  |  |  |  |  |  |  |  |  | 1.5
 | 2013-07-24 00:00:00 |  |  |  |  |  |  |  |  |  | 1.5
 | 2013-07-25 00:00:00 |  |  |  |  |  |  |  |  |  | 1.5
 | 2013-07-26 00:00:00 |  |  |  |  |  |  |  |  |  | 2.5
 | 2013-07-29 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2013-07-29 00:00:00
 | 2013-07-30 00:00:00 |  |  |  |  |  |  |  |  |  | 4.3
 | 2013-07-31 00:00:00 |  |  |  |  |  |  |  |  |  | 5.8
 | 2013-08-03 00:00:00 |  |  |  |  |  |  |  |  |  | 5.7
 | 2013-08-10 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
 | 2013-08-19 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
 | 2013-08-24 00:00:00
 | 2013-08-24 00:00:00
 | 2013-09-07 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
 | 2013-09-14 00:00:00 |  |  |  |  |  |  |  |  |  | 1.5
 | 2013-09-14 00:00:00 |  |  |  |  |  |  |  |  |  | 1
 | 2013-09-15 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
 | 2013-09-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2.7
 | 2013-09-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2.5
 | 2013-09-19 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
 | 2013-09-19 00:00:00 |  |  |  |  |  |  |  |  |  | 2.7
 | 2013-09-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2.3
 | 2013-09-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2.3
 | 2013-09-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2.3
 | 2013-10-04 00:00:00 |  |  |  |  |  |  |  |  |  | 2
 | 2013-10-04 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2013-10-06 00:00:00 |  |  |  |  |  |  |  |  |  | 2.4
 | 2013-10-20 00:00:00 |  |  |  |  |  |  |  |  |  | 0.3
 | 2013-10-28 00:00:00 |  |  |  |  |  |  |  |  |  | 1
 | 2013-10-28 00:00:00 |  |  |  |  |  |  |  |  |  | 2.1
 | 2013-10-29 00:00:00 |  |  |  |  |  |  |  |  |  | 2.3
 | 2013-11-08 00:00:00 |  |  |  |  |  |  |  |  |  | 3.2
 | 2013-11-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2
 | 2013-11-10 00:00:00 |  |  |  |  |  |  |  |  |  | 7.2
 | 2013-11-11 00:00:00 |  |  |  |  |  |  |  |  |  | 5.2
 | 2013-11-12 00:00:00 |  |  |  |  |  |  |  |  |  | 3.5
 | 2013-11-13 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
 | 2013-11-13 00:00:00 |  |  |  |  |  |  |  |  |  | 0.8
 | 2013-11-18 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
 | 2013-11-19 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
 | 2013-11-19 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
 | 2013-11-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2.6
 | 2013-11-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2.7
 | 2013-11-24 00:00:00 |  |  |  |  |  |  |  |  |  | 4
 | 2013-11-25 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2013-11-28 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2013-12-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
 | 2013-12-02 00:00:00 |  |  |  |  |  |  |  |  |  | 2.6
 | 2013-12-04 00:00:00 |  |  |  |  |  |  |  |  |  | 0.9
 | 2013-12-05 00:00:00 |  |  |  |  |  |  |  |  |  | 1
 | 2013-12-08 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2013-12-12 00:00:00 |  |  |  |  |  |  |  |  |  | 3.7
 | 2013-12-13 00:00:00 |  |  |  |  |  |  |  |  |  | 0.2
 | 2013-12-14 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2013-12-15 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2013-12-16 00:00:00 |  |  |  |  |  |  |  |  |  | 0.9
 | 2013-12-17 00:00:00 |  |  |  |  |  |  |  |  |  | 1.5
 | 2013-12-17 00:00:00 |  |  |  |  |  |  |  |  |  | 2.2
 | 2013-12-18 00:00:00 |  |  |  |  |  |  |  |  |  | 5.6
 | 2013-12-18 00:00:00 |  |  |  |  |  |  |  |  |  | 0.4
 | 2013-12-19 00:00:00 |  |  |  |  |  |  |  |  |  | 3.3
 | 2013-12-20 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
 | 2013-12-21 00:00:00 |  |  |  |  |  |  |  |  |  | 5
 | 2013-12-23 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2013-12-25 00:00:00 |  |  |  |  |  |  |  |  |  | 6.5
 | 2013-12-26 00:00:00 |  |  |  |  |  |  |  |  |  | 6
 | 2013-12-27 00:00:00 |  |  |  |  |  |  |  |  |  | 3.5
 | 2013-12-28 00:00:00 |  |  |  |  |  |  |  |  |  | 1.7
 | 2013-12-29 00:00:00 |  |  |  |  |  |  |  |  |  | 1.9
 | 2013-12-30 00:00:00 |  |  |  |  |  |  |  |  |  | 7.3
 | 2013-12-31 00:00:00 |  |  |  |  |  |  |  |  |  | 5.5
 | 2014-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 6.6
 | 2014-01-02 00:00:00 |  |  |  |  |  |  |  |  |  | 4.7
 | 2014-01-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2.6
 | 2014-01-09 00:00:00 |  |  |  |  |  |  |  |  |  | 3.1
 | 2014-01-11 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2014-01-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2.1
 | 2014-01-15 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2014-01-16 00:00:00 |  |  |  |  |  |  |  |  |  | 0.8
 | 2014-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | 1.5
 | 2014-01-19 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
 | 2014-01-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2.8
 | 2014-01-22 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
 | 2014-01-25 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2014-01-27 00:00:00 |  |  |  |  |  |  |  |  |  | 2.2
 | 2014-01-30 00:00:00 |  |  |  |  |  |  |  |  |  | 2
 | 2014-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0.4
 | 2014-02-02 00:00:00 |  |  |  |  |  |  |  |  |  | 1.3
 | 2014-02-03 00:00:00 |  |  |  |  |  |  |  |  |  | 0.8
 | 2014-02-07 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
 | 2014-02-07 00:00:00 |  |  |  |  |  |  |  |  |  | 3.2
 | 2014-02-08 00:00:00 |  |  |  |  |  |  |  |  |  | 0.6
 | 2014-02-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2.5
 | 2014-02-10 00:00:00 |  |  |  |  |  |  |  |  |  | 1.6
 | 2014-02-11 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
 | 2014-02-12 00:00:00 |  |  |  |  |  |  |  |  |  | 4.5
 | 2014-02-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2.7
 | 2014-02-17 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
 | 2014-02-19 00:00:00 |  |  |  |  |  |  |  |  |  | 3.7
 | 2014-02-21 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
 | 2014-02-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2.2
 | 2014-02-22 00:00:00 |  |  |  |  |  |  |  |  |  | 4.3
 | 2014-02-23 00:00:00 |  |  |  |  |  |  |  |  |  | 3.5
 | 2014-02-25 00:00:00 |  |  |  |  |  |  |  |  |  | 3