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...o&userid=34602
View this thread: http://www.excelforum.com/showthread...hreadid=543710