Hi Narkom,
Try this:
=counta(c3:c300,"Madonna")

HTH
Kevin M
"Narkom" wrote:


Hello all, how can I do this:

I have names in column A (cell 3 till 100), and I want to count them.
But, i want that my output shows like this:
f.ex.:

madonna 12 (entrys)
abba 8
50 cent 3
etc.

Hope that someone can help me.
Sorry for my bad english.


--
Narkom
------------------------------------------------------------------------
Narkom's Profile: http://www.excelforum.com/member.php...o&userid=32642
View this thread: http://www.excelforum.com/showthread...hreadid=527312