Auto-sort

Hermansen76

New Member
Joined
Dec 10, 2005
Messages
1
i want to auto-sort a table which are updated with goals and points from a match-schedule after each match. want it to be sort first on points and then goals. (not manually)

points goal
Tromsø 3 3
Ham-Kam 3 2
Fredrikstad 3 0
Molde 3 -3
Rosenborg 1 -1
Vålerenga 1 -1
Brann 0 -2
Odd Gren 3 0
Stabærk 3 -1
Viking 3 -2
Sandefjord 6 3
Lillestrøm 4 1
Lyn 4 1


anyone who can help me?
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,670
Members
412,481
Latest member
nhantam
Top