Sorting Text Column by Most Frequent item

[Rick P.]

I am trying to process a list of several thousand items ( business names) in Excel (imported from Database..
Is there a quick way to sort the text column so the 'most frequently ocurring items' are grouped together nearest the top of the column and vice-versa

I alphabetized the column first, with obvious results... but would like to create a new column showing only 1 ocurrence of each item from the original column, arranged from most common item on list to least common

Thanks in advance..

 

[Ken Wright]

Have you thought about a Pivot table? A good intro:-

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------

I am trying to process a list of several thousand items ( business names) in

Excel (imported from Database..)

Is there a quick way to sort the text column so the 'most frequently ocurring

items' are grouped together nearest the top of the column and vice-versa.

I alphabetized the column first, with obvious results... but would like to

create a new column showing only 1 ocurrence of each item from the original
column, arranged from most common item on list to least common.