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, 10: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

=IF(A1>A2,B1,B2)

this would print "Frank"

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

Thanks

E!
__________________

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

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, 01:34 PM   #3 (permalink)
True Techie
 
Join Date: Feb 2005
Posts: 151
Default

You could do something like the following in VB :

Code:
Sub sort()
    
    ' Change this line to suit your selection requirements [I.E. ("A1:F65536") or ("A:F")]
    Columns("A:B").Select
    
    ' 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
    Range("A1").Select
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 08:49 PM.


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