| Home |
| Search |
| Today's Posts |
|
|
|
#1
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! |
|
#2
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
