Try this on a copy of your data, just in case.

Select both columns of data then go to DataSort, select the column with the
numbers to sort by and select descending. As far as I know this should work,
but the COUNTIF gives me some doubt.

--
Ian
--
wrote in message
oups.com...
I have the following list:
(the numbers and names are in seperate cells)
Michigan State 8
Michigan 9
Minnesota 7
Illinois 7
Indiana 1
Ohio State 2
Iowa 2
Northwestern 1
Purdue 1
Penn State 1


With the numbers being derived from a COUNTIF Function. I want the
list to reorder itself keeping the college with their number and in
numeric order. So Michigan is 9, then Michigan State and so on.

I hope this isn't too fuzzy.