Excel Guru's!!! - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
Thread Tools Display Modes
Old 03-28-2005, 09:18 AM   #1 (permalink)
Newb Techie
Join Date: Sep 2004
Posts: 8
Default Excel Guru's!!!

If I had 20 or so people in a sports pool with weekly points, what funtion would I use to sort them out in order from 1 - 20?

How would I use this function?

The only way I know of is this:

A1=50 B1=Frank
A2=45 B2=Bob


this would print "Frank"

Only problem is this only compares 2, not 20 or more.



psychoe! is offline  
Old 03-28-2005, 09:40 AM   #2 (permalink)
Master Techie
Join Date: Jul 2004
Posts: 2,932

Um...click on the column and click "Sort"...

Why bother with forumlas?


Don\'t hate the player...Hate the game...
ShoobieRat is offline  
Old 03-28-2005, 12:34 PM   #3 (permalink)
True Techie
Join Date: Feb 2005
Posts: 151

You could do something like the following in VB :

Sub sort()
    ' Change this line to suit your selection requirements [I.E. ("A1:F65536") or ("A:F")]
    ' The lines below sort the data, starting with column A in ascending, then column B in ascending order
    Selection.sort Key1:=Range("A1"), Order1:=xlAscending, Key2:=Range("B1") _
        , Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
        False, Orientation:=xlTopToBottom
    ' Select Cell A1 once all data has been sorted correctly
End Sub
Be not afraid of growing slowly, be afraid only of standing still - Knowledge will get you somewhere, stupidity will get you nowhere
Catbert is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 05:36 PM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2018, vBulletin Solutions, Inc.