software

I have the following list:
(the numbers and names are in seperate cells)
Michigan State8
Michigan9
Minnesota7
Illinois7
Indiana 1
Ohio State2
Iowa 2
Northwestern1
Purdue 1
Penn State1With 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.Try this on a copy of your data, just in case.

Select both columns of data then go to Datagt;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.

--
Ian
--
gt; wrote in message oups.com...
gt;I have the following list:
gt; (the numbers and names are in seperate cells)
gt; Michigan State 8
gt; Michigan 9
gt; Minnesota 7
gt; Illinois 7
gt; Indiana 1
gt; Ohio State 2
gt; Iowa 2
gt; Northwestern 1
gt; Purdue 1
gt; Penn State 1
gt;
gt;
gt; With the numbers being derived from a COUNTIF Function. I want the
gt; list to reorder itself keeping the college with their number and in
gt; numeric order. So Michigan is 9, then Michigan State and so on.
gt;
gt; I hope this isn't too fuzzy.
gt;
Thanks that does work to rearrange it, but I'd have to do that every
time the quot;rankingquot; 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.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.

--
Ian
--
gt; wrote in message oups.com...
gt; Thanks that does work to rearrange it, but I'd have to do that every
gt; time the quot;rankingquot; of the numbers changed, buts that's okay
gt;
gt; About the COUNTIF Function, do have an idea of something better? I'm
gt; sort of new to this.
gt;
ok thanks.