Number Each Occurance

[Nanogirl21]

I am trying to number each time a matching search item appears in a list. I am using the below formula and it is not working. If the search term appears 4 times then results says 4 for each item instead of being numbered as 1, 2, 3, 4. How can I number each occurance? Can someone please help. Thank you.

=COUNTIF($D$3:D100,D3),"")

 

[Rick Rothstein]

While I don't see why what you have doesn't work, what happens if you make the D100 absolute; that is, change it to $D$100)?

 

[jtakw]

Hi,

Do you mean this:

Book3.xlsx
	D	E
3	a	1
4	b	1
5	c	1
6	a	2
7	a	3
8	d	1
9	d	2
10	r	1
11	b	2
12	c	2
13	a	4
14	b	3
15	c	3
Sheet949

Cell Formulas
Range	Formula
E3:E15	E3	=COUNTIF(D$3:D3,D3)

 

[Nanogirl21]

While I don't see why what you have doesn't work, what happens if you make the D100 absolute; that is, change it to $D$100)?

Changing to $D$100 did not work.

 

[Nanogirl21]

Hi,

Do you mean this:

Book3.xlsx
	D	E
3	a	1
4	b	1
5	c	1
6	a	2
7	a	3
8	d	1
9	d	2
10	r	1
11	b	2
12	c	2
13	a	4
14	b	3
15	c	3
Sheet949

Cell Formulas
Range	Formula
E3:E15	E3	=COUNTIF(D$3:D3,D3)

Yes, this is exactly what I am looking for! This worked. Thank you.

 

[jtakw]

Yes, this is exactly what I am looking for, but even using that formula it still is not working for me.

=COUNTIF(D$3:D3,D3)

It works if you use the $ symbol Only at the first instance of D$3, use the formula AS-IS shown above.

 

[jtakw]

You Edited while I was replying.

You're welcome, glad you got it working, thanks for the feedback.