I have a spreadsheet with names in column a. Many of the names are duplicates. What I am trying to do is find a way to sort them so that the names can be listed once with a corresponding number to the cell to the right telling me how many times the name is used.
Example:
Column A:
smith
jones
smith
smith
jones
jones
Williams
Barns
Smith
Williams
I want columns B and C to look like this:
smith 4
jones 3
williams 2
barns 1
Thanks
Example:
Column A:
smith
jones
smith
smith
jones
jones
Williams
Barns
Smith
Williams
I want columns B and C to look like this:
smith 4
jones 3
williams 2
barns 1
Thanks