Spreadsheet: 159213d1338552455-get-value-from-cell-above-every-zero-in-column-test
Sheet: Sheet1

I | count zeros between cells with "1" |  |  |  |  |  |  |  |  |  |  |  | II | retrieve value above every zero |  |  |  |  |  |  |  |  |  |  | I |  |  |  |  |  |  |  |  |  |  |  | II
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 2 | 3 | 1 |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 1 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 |  |  | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1
 | 7 | 4 | 2 |  |  |  |  |  |  |  |  |  |  | 7 | 4 | 2 |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  | 2 | 2 | 0 | 1 | 1 | 1 | 2 | 2 | 0 | 2
 | 7 | 4 | 4 |  |  |  |  |  |  |  |  |  |  | 7 | 4 | 4 |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |  |  | 0 | 3 | 1 | 0 | 2 | 2 | 0 | 3 | 1 | 3
 |  | 5 | 4 |  |  |  |  |  |  |  |  |  |  |  | 5 | 4 |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  | 1 | 0 | 2 | 1 | 3 | 3 | 1 | 0 | 2 | 4
 |  | 5 | 8 |  |  |  |  |  |  |  |  |  |  |  | 5 | 8 |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2 | 1 | 0 | 2 | 4 | 4 | 2 | 1 | 3 | 5
 |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  | 3 | 2 | 1 | 3 | 5 | 5 | 3 | 2 | 4 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |  |  | 4 | 3 | 2 | 4 | 6 | 0 | 4 | 3 | 5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 5 | 4 | 3 | 5 | 7 | 1 | 5 | 4 | 6 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 6 | 0 | 4 | 6 | 8 | 2 | 6 | 5 | 7 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  | 7 | 1 | 0 | 7 | 9 | 3 | 7 | 0 | 8 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 |  |  | 0 | 2 | 1 | 8 | 10 | 4 | 0 | 1 | 0 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 | 3 | 2 | 0 | 11 | 5 | 1 | 2 | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2 | 4 | 3 | 1 | 12 | 6 | 2 | 3 | 2 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  | 3 | 0 | 4 | 2 | 13 | 7 | 3 | 4 | 3 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  | 4 | 1 | 0 | 3 | 0 | 8 | 4 | 5 | 4 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 5 | 2 | 1 | 4 | 1 | 9 | 5 | 6 | 5 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 6 | 3 | 2 | 5 | 2 | 10 | 6 | 7 | 6 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 7 | 4 | 3 | 6 | 3 | 0 | 7 | 8 | 7 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 5 | 4 | 7 | 4 | 1 | 8 | 9 | 8 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  | 1 | 0 | 5 | 8 | 5 | 2 | 9 | 0 | 9 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2 | 1 | 6 | 9 | 6 | 3 | 10 | 1 | 10 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | 2 | 7 | 10 | 7 | 4 | 11 | 2 | 11 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 |  |  | 4 | 3 | 8 | 11 | 8 | 5 | 0 | 3 | 0 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 5 | 4 | 0 | 12 | 9 | 6 | 1 | 4 | 1 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |  |  | 6 | 5 | 1 | 13 | 10 | 7 | 2 | 0 | 2 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 7 | 0 | 2 | 0 | 11 | 8 | 3 | 1 | 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 |  |  | 8 | 1 | 3 | 1 | 0 | 9 | 4 | 2 | 0 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 9 | 2 | 4 | 2 | 1 | 10 | 5 | 3 | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 10 | 3 | 0 | 3 | 2 | 11 | 6 | 4 | 2 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  | 11 | 4 | 1 | 0 | 3 | 12 | 7 | 5 | 3 | 0