Grouping a column of data and displaying the number of items grouped

[henry.fullalove]

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!

 

[Mike H]

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

 

[Herbert Seidenberg]

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