Quote:
Originally Posted by mrbucket
Hey, I made an edit to the spreadsheet that you'll find useful. Google Sheets has a function called SORT that lets you define an array that you want to be automatically sorted. You can have the spot where you're entering data to be alphabetical and then off to the right hand sort, you can have the same info that automatically sorts itself by winning %.
More info here: https://support.google.com/docs/answer/3093150?hl=en |
Thanks, I'll check it out. I've been sorting after the data is entered, and that's where I get my mistakes. I'm gonna check out Maxfire's suggestion about making the references in the loss column absolute, since that's where the problems crop up. Doesn't make sense to me why they change, but that doesn't mean it's not logical that they do.
