Sort by the column in descending order?
I am currently in the process of creating a league table using Excel, and was wondering how I could get the teams to automatically arrange themselves in order of total points?, without using macros, is any formula capable of this?
Last edited by Freddie2007; November 21st, 2006 at 17:43.
Just sort the table by the required column.
Or, create a Dynamic Named Range called MyTable and use the Worksheet Change Event Code below. It assumes you wish to sort by the 1st column in your table.
VB:Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("MyTable")) Is Nothing Then With Range("MyTable") .Sort Key1:=.Cells(1, 2), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End With End If End Sub
Last edited by Dave Hawley; November 21st, 2006 at 17:42.
Thanks, I did that and was able to sort the final column, the total points column, in descending order, but how can I set it to sort the first column which contains every teams position in the league, numerically also, as every time I try to sort it, it messes up the total points column.
Thanks for your help guys but I just cant get it to work, I've tried the rank formula but I keep getting back error messages, does anyone know what formula I could use?, there are 25 teams, the total points column is column I, and I want it ranked in ascending order, help me!
There are currently 1 users browsing this thread. (0 members and 1 guests)