I am creating a custom game in which users get to load items into a cart and get points for them.
I have the point value being logged in an excel sheet, along with the players name and email. The client wanted to have a leaderboard displayed, and I got as far as linking text to the first 3 rows of that spreadsheet. The only issue I am having is that it doesn’t sort based on whoever has the most points.
It looks like Excel isn’t able to auto sort while it is closed, is there a workaround for this without starting over in regards to the way we are keeping score?
Only issue I am coming across is that the values seem to be inputted into excel in alphanumerical order, so for example, 1050 appears below 1000 in point value because its alphabetical.