Alan Beban wrote...
Just out of curiosity, are your names grouped or ungrouped? If they
are
in fact grouped, then the simplest approach first posted should be
considered.

Granted. If names are grouped, then Alan's original formula is optimal.

However, OP showed unsorted sample data. What's the *reasonable*
assumption to make when presented with unsorted data?