count consecutive numbers/entries in column

[Future]

I have a column with 54127 rows. The entries are 1, false, or blank.
Many of these 3 possible entries are consecutive.

In the next 3 columns I would like a formula that will count the consecutive
1's, false, or blank entries. Each of the three new columns will reference
separately the 3 possible entries.

Using Excel 2007.

Thanks for any help/ideas.

 

[barry houdini]

If you have data in A2 down then with B1:D1 blank or text headers you can use this formula in B2

=IF(A2=1,SUM(B1,1),"")

and in C2

=IF(A2="",SUM(C1,1),"")

and in D2

=IF(AND(A2=FALSE,A2<>""),SUM(D1,1),"")

Now select B2:D2, type B2:D52128 in the box above A1 to select the whole range....and then CTRL+D to populate the formulas into that range

 

[Future]

Mr. Houdini....

truly magical reply....works great!

Many thanks!

 

[Future]

If you have data in A2 down then with B1:D1 blank or text headers you can use this formula in B2

=IF(A2=1,SUM(B1,1),"")

and in C2

=IF(A2="",SUM(C1,1),"")

and in D2

=IF(AND(A2=FALSE,A2<>""),SUM(D1,1),"")

Now select B2:D2, type B2:D52128 in the box above A1 to select the whole range....and then CTRL+D to populate the formulas into that range

Can this formula be modified to show only the last of the consecutive numbers?
For example one sequence displays 1-54 in the column. I would like just the 54
to be displayed. Thanks for any assistance.