我正在使用Google Form来收集有关游戏玩家及其分数的信息，并试图创建排行榜。
我在Col A中使用了一个Arrayformula来带回每个玩家的唯一值，然后在Col B中的另一个值来表达他们的分数。因此，这是一个排行榜，我希望它通过得分下降来自动选择。
我已经尝试使用各种脚本等，但是似乎即使仅使用排序函数也不起作用。它排序一秒钟，然后重置为播放器出现在表单响应上的顺序。我认为这意味着我无法以这种方式对动态数据进行排序。
关于我如何自动进行的任何想法，因此，即使添加了更多的玩家，它也会始终充当排行榜？
编辑以添加链接：
I'm using a googleform to collect info about game players and their scores for different games, and am trying to create a leaderboard.
I've used an ARRAYFORMULA in col A to bring back unique values of each Player, then another in col B to SUMIF their Scores. So it's a leaderboard, I want it to autosort by score descending.
I've tried using various scripts etc but it seems that even just using the Sort function doesn't work. It sorts for a second, then resets back to the order the Players appear on the Form Responses. I'm taking this to mean I can't sort dynamic data in this way.
Any ideas on how I can autosort this, so even when more Players are added it will always act as a leaderboard?
EDITED TO ADD LINK:
https://docs.google.com/spreadsheets/d/1oitJrH-TdeRFfHCCTf9XO2ma4qwN571cPkYJhhPKKi8/edit?usp=sharing
screenshot of googlesheet
发布评论
评论（1）
尝试：
try: