Try this...

Let's assume you want the list of unique names to be placed in column D starting at cell D1.

Select the range of names in column A including the column header.

Goto the menu Data>Filter>Advanced
Select: Copy to another location
List range should already be entered
Copy to: D1
Select: Unique records only
Click OK

Enter this header in E1: Totals

Enter this formula in E2:

=COUNTIF(A:A,D2)

Copy down as needed.