Yet another Excel question
Let's say I have a small spreadsheet. One column, 1000 cells long. All names of some sort. Many names are repeated.
I want to know exactly how many of each name are in this column without having to write a formula for each name. Example:
dan
dan
alice
bob
mark
jack
jack
alice
bob
jack
mark
I could write "=countif($a$1:$a$12,"dan") - that would tell me how many times "dan" appears in the column. And then do that for every name. But you can see how this might be tough with so many different names in the column.
At home I just have Excel 2000, and it's not helpful.
I want to know exactly how many of each name are in this column without having to write a formula for each name. Example:
dan
dan
alice
bob
mark
jack
jack
alice
bob
jack
mark
I could write "=countif($a$1:$a$12,"dan") - that would tell me how many times "dan" appears in the column. And then do that for every name. But you can see how this might be tough with so many different names in the column.
At home I just have Excel 2000, and it's not helpful.