sorting a range

cjsmith22

New Member
Joined
Nov 2, 2005
Messages
22
i have some code which sorts a league table, firstly by column n (pts), then if pts are equal - column m (goal diff)
Code:
Range("A19:N38").Select
    Range("N19").Activate
    Selection.sort Key1:=Range("N20"), Order1:=xlDescending, Key2:=Range( _
        "M20"), Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase _
        :=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, _
        DataOption2:=xlSortNormal

if the values in column m are equal how do i then do an extra sort based on - columnf + columnk (goals scored)
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
One way would be to add another column with the goals for totalled (you could have this hidden if you wished), e.g. in column O and then add column O to your sort range and a 3rd key sorting on column O
 

Watch MrExcel Video

Forum statistics

Threads
1,118,285
Messages
5,571,310
Members
412,381
Latest member
RogerL
Top