Hi Andrew,

Assuming your data starts in B2, and A1 is not a number, enter this in
A2 and copy it down.

=IF(B2=B1,A1,A1+1)

Hope this works for you,

Gary