I Need Help with Counting Consecutive Cells

Hi,

I have a piece of equipment which tracks the number of times an organism moves within a certain unit of time (e.g. 30s). The numbers are registered in columns. If the organism does not move in that time frame, the cell is left blank. If it moves once, the number 1 appears, if twice the number 2 appears, and so on.

I would like to create a formula by which I count the number of more than 1 consecutive blank cells in each column. The values would ideally be posted across a row, in a different sheet.
e.g.

2
3
1
2
3
1
5

So the count for this column would be:

4

2

2

As stated, the 1 blank cell would not be counted, since values greater than 1 are needed.

The row shows how the formula should present the results. I'm not interested in the number of times that blanks occurs, but rather the size of each consecutive blank occurrence of >1. The size of each occurrence needs to be represented in a separate cell. That's what's on show in the rows.

Thus:

1. The first occurrence of >1 blank, there were 4 blanks, as shown in the first cell of the row.
2. The second occurrence of >1 blank, there were 2 blanks as shown in the second cell of the row.
3. The third occurrence of >1 blank, there were 2 blanks as shown in the third cell.

Any help would be greatly appreciated, this is kind of urgent. Thanks!

See attached.

Formula in Column B records count of blanks between values.

Put in B2

=IF($A1<>"",IF(COUNTA($A2:$A1000),MATCH(TRUE,$A2:$A1000<>"",0)-1,""),0)

Enter with Ctrl+Shift+Enter

Copy down as required

Formula in D1 extracts counts > 1 and puts them in the row,

in D1

=IFERROR(INDEX($B$1:$B$16,SMALL(IF($B$1:$B$16>1,ROW($B$1:$B$16)-ROW($B$1)+1,""),COLUMNS($A$1:A1))),"")

Enter with Ctrl+Shift+Enter


Drag formula across row as required