[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.