Quote:
Originally Posted by Stanley Kuppchaser
In an effort to make doing two sets of standings a little less time consuming, I post the stats in Google sheets. However, when I use the sort function to sort them by winning pct., some of the formula references get screwed up. It seems somewhat random.
Here;s what I do:
I highlight the cells I want to sort, including the header at the top of the columns, but not the title header.
Then I define the sort range to sort the data from high pct. to low using that column only.
It sorts the standings correctly, but I usually get several #ref errors in the loss column. Once I straighten those out it does fine, and the pct. sort is correct as it stood.
There doesn't seem to be a pattern to it that I can discern. I've tried eliminating the header row from the sort, but that seems worse.
Any thoughts? It's killing the time savings.
Thanks.
|
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