How about making pivot table by choosing the inputted names as rows and count of the names as a column???? After you input a name you would just have to refresh the pivot table. (You just have to be sure that the ranges of the pivot table are large enough to cover all the possible rows)
|