Sorting

[holmdeal]

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.

 

[Ian]

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

Select both columns of data then go to Data>Sort, 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.

 

[holmdeal]

Thanks that does work to rearrange it, but I'd have to do that every
time the "ranking" of the numbers changed, buts that's okay

About the COUNTIF Function, do have an idea of something better? I'm
sort of new to this.

 

[Ian]

Not really. If COUNTIF works for you, that's fine. I just wasn't sure if
sorting the data would upset the COUNTIF in some way. It sounds like it
doesn't.

 

[holmdeal]

ok thanks.