Restart row count each time the value in a specific column changes

[RC]

Is there a formula that will restart the row count when the value in a
specific column changes --- such as shown below when the value in column A
changes the row count in column B restarts?

A B
1 452 1
2 452 2
3 452 3
4 452 4
5 329 1
6 329 2
7 548 1
8 548 2
9 548 3

Thanks in advance

 

[Max]

Here's one ..
In B1, copied down: =COUNTIF(A$1:A1,A1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik

 

[RC]

Thanks Max, that works great!
--
RC

Here's one ..
In B1, copied down: =COUNTIF(A$1:A1,A1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik

 

[Max]

Welcome, thanks for feeding back
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik