R
Russ
Hello,
I have a sheet with a long column of names. Many are
duplicated 2-10 times. I need a way to count the number
of times each unique name ocurrs. Example:
ColA
Jim
Bob
Jim
Sally
Bob
Aaron
Alice
Bob
I want to end up with a count for each name:
Bob 3
Jim 2
Sally 1
Aaron 1
Alice 1
The list is long with many names so I don't want to do a
CountIf(A1:A500,"Bob") for each one unless there is a way
to automatically put each unique "Name" in.
Any suggestions?
Thanks
Russ
I have a sheet with a long column of names. Many are
duplicated 2-10 times. I need a way to count the number
of times each unique name ocurrs. Example:
ColA
Jim
Bob
Jim
Sally
Bob
Aaron
Alice
Bob
I want to end up with a count for each name:
Bob 3
Jim 2
Sally 1
Aaron 1
Alice 1
The list is long with many names so I don't want to do a
CountIf(A1:A500,"Bob") for each one unless there is a way
to automatically put each unique "Name" in.
Any suggestions?
Thanks
Russ