Counting instance # for criterion in other cell

[virtuosok]

Hi,
I have two columns as follows (let's say they are column A and column B)

Jennifer	1
John	2
Jack	3
John	4
Jennifer	5
Jack	6
Jack	7
Jack	8
John	9
Jennifer	10

I need a formula for column C which would tell me the instance # for the adjacent entry in column B, for a person in column A. In other words, I would need the formula to return
"1" for Jennifer 1
"2" for Jennifer 5
"3" for Jennifer 10
Thanks for your suggestions!

 

[Peter_SSs]

Is this what you mean?

21 09 10.xlsm
	A	B	C
1
2	Jennifer	1	1
3	John	2	1
4	Jack	3	1
5	John	4	2
6	Jennifer	5	2
7	Jack	6	2
8	Jack	7	3
9	Jack	8	4
10	John	9	3
11	Jennifer	10	3
Instance

Cell Formulas
Range	Formula
C2:C11	C2	=COUNTIF(A$2:A2,A2)

 

[virtuosok]

Yes, thanks!

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.