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.
|
If your sorting is messing with the rows/columns and resulting in changes to the cells you're referencing, try making it an absolute reference. It would look like $C$10 and then it would always reference cell C10 regardless of any sorting changes.
I might be misunderstanding your problem though.