Grouping a column of data and displaying the number of items group
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!
|