Thread: Sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Sorting

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.