need to calculate if two same random number run in a row

[evan20002]

=INT(1+RAND()*5)

I run 3000 random numbers &

need to calculate if two same number run in a row
and another same number follow and run in a row

4
4
5
5

then highlight it and count how many time it occur after 3000 figures.


thanks
Evan

 

[mikerickson]

Try
=SUMPRODUCT(--(A1:A3000=A2:A3001)*(A3:3002=A4:3003))