Formula to show number of same numbers (0 or 1) in a row

Hi Guys,

I was wondering if anyone had a formula that I can drag UP column B here, that would show the number of consequentive 0's or 1's as shown in the example below:

A B

0 3
0
0
1
0
1 2
1
0


My data set has approx 2000 values as in column A so a formula for this would be very helpful!

Also Remember we are working UPWARDS, very important here.

Thank you so much!

Ben

Thanks so much, hats exactly what I wanted to do!

Now would it also be possible to do the following:

I am looking to bet that sequence continues like the last digit. so as below, the first digit is 0, so i bet 0 = WIN, the next number is 0 = win. the next number is one = LOSS. Coversely the same for 1's = 2 or more 1's in a row = win.

example of it is below:

A B


0
0 WIN
0 WIN
1 LOSS
1 WIN
0 LOSS
1 LOSS
0 LOSS


Thanks again!

Ben