Counting Consecutive values and saving them

I want to count consecutive values and save each value to a report. So I have hundreds of these, 1 col wide, 48 rows. These contain the word blank and this is what I want to count. I want to count consecutive blanks. So the example below I would have a report that shows me....

Consecutive Blanks with corresponding count value
1 consecutive blanks = 2
2 consecutive blanks = 2
3 consecutive blanks = 2
4 consecutive blanks = 2
5 consecutive blanks = 0
6 consecutive blanks = 0
7 consecutive blanks = 0
8 consecutive blanks = 0


You get the idea....don't have to show 0's. I would want to be able to select multiple sheets within 1 book.


Blank
Blank
Server
Server
Server
Server
Server
Server
Blank
Server
Server
Server
Server
Server
Server
Server
Server
Server
Blank
Server
Server
Server
Blank
Blank
Blank
Blank
Server
Server
Blank
Blank
Blank
Server
Server
Server
Blank
Blank
Blank
Server
Server
Server
Blank
Blank
Server
Server
Blank
Blank
Blank
Blank

Try this:-
Data column "A" Results column "C".

Please Login or Register  to view this content.

Regards Mick

just for variety

Please Login or Register  to view this content.