Count Records

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

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
 
Hi Ashish,

Thks for your advise, but it only start with the counter "1" instead of "0".
How can I make use of this?

Cheers
Simon
 
Back
Top