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:

smith smith 4
jones jones 3
smith williams 2
smith Barns 1
jones
jones
Williams
Barns
Smith
Williams

Thanks