Count multiple occurances in a column
 

Hello-
I read thru many posts, but none have the same question - I don't think.

I have a column with names in it, maybe 50 unique names, but the column is
2000 cells long. I would like to know how many times each of the names is in
the column.

Sally = 25
Tom = 333
Bob = 2
etc.

Thank you so much!

Count multiple occurances in a column
 

=countif(a1:a2000,"sally")

"DTTODGG" wrote:

Hello-
I read thru many posts, but none have the same question - I don't think.

I have a column with names in it, maybe 50 unique names, but the column is
2000 cells long. I would like to know how many times each of the names is in
the column.

Sally = 25
Tom = 333
Bob = 2
etc.

Thank you so much!

Count multiple occurances in a column
 

Thank-you will, but, this would take 50+ IFs?
Is there a way to look for all the names and then count them?
Thanks

"will A" wrote:

=countif(a1:a2000,"sally")

"DTTODGG" wrote:

Hello-
I read thru many posts, but none have the same question - I don't think.

I have a column with names in it, maybe 50 unique names, but the column is
2000 cells long. I would like to know how many times each of the names is in
the column.

Sally = 25
Tom = 333
Bob = 2
etc.

Thank you so much!

Count multiple occurances in a column
 

Use a pivot table. Then it won't matter how many different names there all.
It will count them all.

Make the name field both a row field and a data field. Ensure that the data
field(s) setting is set to count.

Excels help is pretty good on pivot tables as well.

Hope this is a start.

Bill Horton

"DTTODGG" wrote:

Thank-you will, but, this would take 50+ IFs?
Is there a way to look for all the names and then count them?
Thanks

"will A" wrote:

=countif(a1:a2000,"sally")

"DTTODGG" wrote:

Hello-
I read thru many posts, but none have the same question - I don't think.

I have a column with names in it, maybe 50 unique names, but the column is
2000 cells long. I would like to know how many times each of the names is in
the column.

Sally = 25
Tom = 333
Bob = 2
etc.

Thank you so much!

Count multiple occurances in a column
 

Use a pivot table, add a header. select the range header and all and do
datapivottable and pivotchart report, click next twice, click layout,
drag the header into the row and the data areas, click OK, click finish

done


--

Regards,

Peo Sjoblom


"DTTODGG" wrote in message
...
Thank-you will, but, this would take 50+ IFs?
Is there a way to look for all the names and then count them?
Thanks

"will A" wrote:

=countif(a1:a2000,"sally")

"DTTODGG" wrote:

Hello-
I read thru many posts, but none have the same question - I don't
think.

I have a column with names in it, maybe 50 unique names, but the
column is
2000 cells long. I would like to know how many times each of the names
is in
the column.

Sally = 25
Tom = 333
Bob = 2
etc.

Thank you so much!

Count multiple occurances in a column
 

If you are not familiar with pivot table (which is also a solution)
Put all your 50 names in B1:b50, in C1 type =countif(A1:a2000,B1:B50) and
copy up to C50.

"DTTODGG" wrote:

Thank-you will, but, this would take 50+ IFs?
Is there a way to look for all the names and then count them?
Thanks

"will A" wrote:

=countif(a1:a2000,"sally")

"DTTODGG" wrote:

Hello-
I read thru many posts, but none have the same question - I don't think.

I have a column with names in it, maybe 50 unique names, but the column is
2000 cells long. I would like to know how many times each of the names is in
the column.

Sally = 25
Tom = 333
Bob = 2
etc.

Thank you so much!

Count multiple occurances in a column
 

Much happiness in Muddville!
Thank-you for your 3 solutions! I'm learning a lot with all of your help.
This is a great resource. Someday I hope to be answering questions, but for
now...
Again, thank-you!

"DTTODGG" wrote:

Thank-you will, but, this would take 50+ IFs?
Is there a way to look for all the names and then count them?
Thanks

"will A" wrote:

=countif(a1:a2000,"sally")

"DTTODGG" wrote:

Hello-
I read thru many posts, but none have the same question - I don't think.

I have a column with names in it, maybe 50 unique names, but the column is
2000 cells long. I would like to know how many times each of the names is in
the column.

Sally = 25
Tom = 333
Bob = 2
etc.

Thank you so much!

Count multiple occurances in a column
 

Sorry should be =countif($a$1:$a$2000,b1:b50) with the dollar sign.

"DTTODGG" wrote:

Much happiness in Muddville!
Thank-you for your 3 solutions! I'm learning a lot with all of your help.
This is a great resource. Someday I hope to be answering questions, but for
now...
Again, thank-you!

"DTTODGG" wrote:

Thank-you will, but, this would take 50+ IFs?
Is there a way to look for all the names and then count them?
Thanks

"will A" wrote:

=countif(a1:a2000,"sally")

"DTTODGG" wrote:

Hello-
I read thru many posts, but none have the same question - I don't think.

I have a column with names in it, maybe 50 unique names, but the column is
2000 cells long. I would like to know how many times each of the names is in
the column.

Sally = 25
Tom = 333
Bob = 2
etc.

Thank you so much!