Excel Sorting

[fallngod]

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

 

[Casey]

fallngod,
I would add a helper column to the left of your column of company
names. In that column place the following formula: =COUNTIF(B:B,B2)
where column B is where your company names are and B2 is the first
company name. Then copy this formula down your helper column, in this
case column A. Then sort "Descending " on the helper column.

HTH