Thanks Max, that works great!
--
RC
"Max" wrote:
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" wrote:
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
--
RC