Question about automatically sorting data

kzgilson

New Member
Joined
Jan 23, 2004
Messages
3
I have tried browsing the board to find an answer to my question, but I can't seem to find one. I have a spreadsheet that contains the standings for ACC (Atlantic Coast Conference) men's basketball.

I have the following 8 header columns in cells b26 to i26. Team Name, Conference Wins, Conference Losses, Conference Winning %, Overall Record, RPI Ranking, AP Poll Ranking, ESPN Poll Ranking.

There are 9 rows of data that I am sorting (for the nine teams in the ACC).

I want to have the data sort automatically by winning % (in descending order) and then by RPI ranking (in ascending order) so that when winning % is updated the standings are automatically updated. If anyone can help me with this, it would be much appreciated.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Simple solution:

Record a macro sorting the column as you suggest.

Create a macro button on the worksheet. Assign the recorded macro to the button. When you update the scores etc - press the button to re-sort the data.

The only other way is to use a change event - and these (in my opinion) are cumbersome as they will run whenever you change anything on the sheet, obviously you can insert a clause to exit the code pending the active cell but it's probably not worth all the agro to be honest.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,895
Messages
5,766,978
Members
425,392
Latest member
Booknerd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top