Count number of times a text occurs

Lee · Oct 11, 2008

I want to count the number of times a text occurs in a range and then put
1,2,3,ect in a cell adjacent to the occurance.
Apple 1
Apple 2
Apple 3
Apple 4
Banana 1
Banana 2
Banana 3
I can use the count function but it doesn't seem to help with the numbering.
It seems like it should be simple but it probably isn't.
Thanks for any help.

Don Guillett · Oct 11, 2008

Try this, copied down
=COUNTIF($H$2:H2,H2)

Lee · Oct 11, 2008

Thanks, it works very well. I don't understand why but it does work.
Thanks,
Lee

Don Guillett said:
Try this, copied down
=COUNTIF($H$2:H2,H2)

Don Guillett · Oct 11, 2008

Glad to help
The $h$2 anchors at the first cell to count. Then you look from there down
and check each cell against that.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

Lee said:
Thanks, it works very well. I don't understand why but it does work.
Thanks,
Lee