Excel Sorting
 

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

Excel Sorting
 

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


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=543710