Excel question: How to Mark Duplicates in Sequence?

J

JamiesonC

New member
Joined
Mar 12, 2009
Messages
1
Reaction score
0
Points
1
Sorry, i don't know how to word this so here's an example...

I want to count the number of duplicates of a particular value within a range, but i want them to be numbered according to when they appear in the range, so for example, here are some sample values

James
Bob
James
James

I know how to count them, using COUNTIF, but i want them to look like this;

James 1
Bob 1
James 2
James 3

is there any way to do this?
 
Back
Top