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!

Hi,

It takes a couple of steps.
Select yoyr column of names then
Data|Filter|Advanced filter
Select Copy to another location and enter (or navigate to) the location
Select unique records only
Click Ok
You will have a list of unique names in this new location which in my case
is column E on the same sheet
In F2 adjacent to the first name enter the formula
=COUNTIF(A:A,E2)
Where AA is the original list. Drag down to the length of the new list.

Mike

" wrote:

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!

Or use Pivot Table.
No formulas
Refreshable
Sorted automatically
Expand automatically with List (Excel 2003)
or Table (Excel 2007)
http://www.freefilehosting.net/download/3fej2