Excel Sorting

Giganews Newsgroups
Subject: Excel Sorting
Posted by:  fallngod (fallngod.28244a_1148045701.8464@excelforum-nospam.com)
Date: Fri, 19 May 2006

I have an excel sheet with 3 columns, and about 2000 rows.  Column A
contains the name of several companies.  The company names appear
several times.  How can I create a function that goes through all the
names and Sorts the most reoccurying name.

Example:

Walmart
Fila
Nike
Walmart
Fila
Bank of America
Fila
Walmart
Nike
Walmart

List should then look like:
Walmart
Walmart
Walmart
Walmart
Fila
Fila
Fila
Nike
Nike
Bank of America

--
fallngod
------------------------------------------------------------------------
fallngod's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34602
View this thread:http://www.excelforum.com/showthread.php?threadid=543710

Replies