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

 Techist - Tech Forum Excel Guru's!!!
 Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 03-28-2005, 09:18 AM #1 (permalink) Newb Techie   Join Date: Sep 2004 Posts: 8 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! __________________
 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...
 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 : 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

 Thread Tools Display Modes Linear Mode

 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 OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

#### Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

#### Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

#### Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities