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

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

I think you probably meant countif:

=COUNTIF(C3:C300,"Madonna") and I think the OP has the data in column A.
But that said, I probably would have used =countif(a3:a100, "abba") because I
love some of Abba's songs :)

--
Kevin Vaughn


"Kevin M" wrote:

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

Actually, come to think of it, you probably want the artist's name in a cell
and have the formula reference the cell, like this (assumes artist name in
B2):

=COUNTIF($a$3:$a$100,B2)

--
Kevin Vaughn


"Kevin Vaughn" wrote:

I think you probably meant countif:

=COUNTIF(C3:C300,"Madonna") and I think the OP has the data in column A.
But that said, I probably would have used =countif(a3:a100, "abba") because I
love some of Abba's songs :)

--
Kevin Vaughn


"Kevin M" wrote:

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

the problem is that i must show the output in sheet 2 and all the data
is in
sheet 1.
What if I dont´t know the names listed in the column A?
Thank you all for the help


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

That's a good point. Peo's method also worked for me.
--
Kevin Vaughn


"Pete_UK" wrote:

Kevin,

whenever I want to extract unique values, I always copy the column(s)
into another sheet and then do Data | Filter | Advanced filter there,
usually copying into another location and then deleting the column(s)
with the original data in. This could form the start of Narkom's
Sheet2, or if he had already set something else up on that sheet then
the extracting could be done to Sheet3 and the unique list copied over
to Sheet2.

Hope this helps.

Pete

thank you all, now it works :)
but now when i want to calculate the entrys i must
do Data | Filter | Advanced Filter every time!
but what appens when i add new items to sheet1?
Is it possible that excel keeps sheet2 actual with all entrys of
sheet1?
I think on the calculate key f9.
Perhaps it is possible when i hit F9 that sheet2 makes an actualization
of sheet1?!
Sorry for my bad english
Hope you all understand me
Rui


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

Starting with Sheet1 (only), you could record a macro while you:

insert a new Sheet2;
copy column A from Sheet1 to Sheet2;
apply Data | Filter | Advanced Filter copying your unique records to
Sheet2!$C$1;
delete columns A and B;
enter the formula in B2 and copy down.

You can allocate a shortcut key when you set up the macro (eg
CTRL-SHIFT-C), and in future, you could just re-run the macro with this
shortcut key whenever you add new items to Sheet1 - just rename or
delete Sheet2 first.

Hope this helps.

Pete