| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
| generate multiple rows based on cell value | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Hybrid Mode
