Copy the list to another column with an intervening blank column. Select that column and do Data:Remove Duplicates.
To the right of the first name in the now duplicate free column, enter the formula:
=countif(a:a,c1)
Copy the equation down to the end of the list.
|