Hi.
In cell B2, enter =countif($A$$2:A2,A2)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Simon" wrote in message
...
I hv a list of records in Column A which may be duplicated more than once.
What I'd like to do is count the number of record in the list which start
the
counter by 0,1,2,3... and provide the result in Column B
here's a sample of the list:-
Column A Column B
ABC0001 0
ABC0001 1
ABC0001 2
ABD0001 0
ABD0001 1
ABE0001 0
ABE0001 1
ABE0001 2
ABE0001 3