I have a long list, in one column, of names. What I want to do is
output (on another sheet perhaps?) a condensed list, showing the name,
in alphabetical order, followed by the number of times it occurs. I
know I can do it by specifying it manually, but i've a massive list
and it'll be a great headache to do that! Is there anything I can run
automatically to do this for me?

Any help is gratefully received!