Hi Experts,

i want VBA code to Find all instances of a specific string and copying the number of count in cell

ID Name
1 Joan
2 Smith
3 joan
4 Smith
5 Joan

i want to count and save the names in another column. If its first occurrence then 1, if second then 2, and so on.

so i should get answer like :

ID Name Counter
1 Joan 1
2 Smith 1
3 Joan 2
4 Smith 2
5 Joan 3
6 Joan 4

Any help ?