Assuming your data starts in cell A2 and your numbering starts in cell B2 you could enter into cell B2 the line "=IF(A2=A1,B1+1,1)", then press return. Finally double click the bottom RHS of cell B2...