By using this site, you agree to our Privacy Policy and our Terms of Use. Close
non-gravity said:
TWRoO said:

non-gravity asked for the spreadsheet so he got it, all he has to do is put in the weeks numbers, and unless he knows something more about excel than me and can do it automatically there is then only about 2-3 minutes of re-ordering.

What I found out this week is that you can just select columns "Entrant" to "Week #".

Right click > Sort > Alternative Sort or something > Sort by > Week #

I supposed you knew before, but it should really take 10 sec :p

That's how I do it yes, I highlight the data I want sorting and use the "sort" button under the "data" tab in the ribbon.

to do it for the weekly data alone is 10 seconds worth yeah, but I also have to do the same for the 8 sections in the sheet I named "console"