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