Create Count Sequence Into Cell

[dirk1965]

Is there a simple way of creating a numberic count sequence for one column (B) based on when another column (A) value changes therefore restarting the count value?

Example:

Column A | Column B

1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
2 | 1
2 | 2
3 | 1
3 | 2
3 | 3
3 | 4

Thanks

 

[Joe4]

Let's say that your data starts in cell A1.
In B1, enter 1.
Then in B2, enter:
=IF(A2=A1,B1+1,1)
and copy down for all rows.

 

[dirk1965]

Awesome... Thanks! Easier than I thought