Rearranging the Rankings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom G - 10 Dec 2006 03:27 GMT

Hi,

Tom 3
Bob 4
Ed 2
Jane 1

According to other criteria in a prearranged spreadsheet these four
people ranked one through four this week in a contest.

Is there a way to rearrange their names (adding a new column(s) is
fine) so that they form a column(s) one though four next to their
rankings?

Ex: Using existing criteria in two new columns you would get:

Jane 1
Ed 2
Tom 3
Bob 4

Many thanks as always,

Tom

Reply to this Message

Bob Umlas - 10 Dec 2006 04:00 GMT

Select them all and Sort them on the 2nd column. Or am I missing something?

> Hi,
>
[quoted text clipped - 20 lines]
>
> Tom

Reply to this Message

Tom G - 10 Dec 2006 05:34 GMT

>Select them all and Sort them on the 2nd column. Or am I missing something?
>
[quoted text clipped - 22 lines]
>>
>> Tom

Duh! No, you're not missing anything--I am. I was tired and just
coudn't think. It's done.

Thanks

Reply to this Message

Rate this thread: