Here's an alternative using a "helper" column taken from an old ddl post which i have stored.

Using the setup in the previous attachment, insert a new column A to the left of your names and use this formula in A1 copied down to give a unique rank

=RANK(C1,C$1:C$16)+COUNTIF(C$1:C1,C1)-1

then in G1 copied down to list the names in order

=VLOOKUP(ROWS(G$1:G1),A$1:B$16,2,0)