i have some code which sorts a league table, firstly by column n (pts), then if pts are equal - column m (goal diff)
if the values in column m are equal how do i then do an extra sort based on - columnf + columnk (goals scored)
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)