Messages In This Thread

CombatEX · (This post was last modified: 11-13-2012 04:32 PM by CombatEX.)

Thanks, I did find the sort function, and it kind of works. I just need to figure out how to get it to work properly now. I think I might have set up my file in an unideal manner because whenever I sort it changes the values of some of the numbers. It does sort correctly based on the new values, but needless to say I want it to sort the original ones, not these incorrect ones. I believe the issue is that I didn't enter numerical values for the points, but instead designated point values in different cells and then used = to extract that value from the other cell. As a result, when it sorts it doesn't just move the numbers like it should, but instead decides to extract numbers from incorrect cells. For example, before sorting I'll have a cell that says =B14, but after sorting it says =B13 so the points awarded have been changed from those designated by B14 to those by B13.

Well anyway, doesn't matter at this point. I'll just keep it in mind for Season 2 and input my numbers in a more boring way =) Actually, the reason I initially took values from other cells instead of just plain numbers was so that I could easily change the points awarded for different ranks (just change the value of that one cell to update the entire spreadsheet), but now that I'm pretty certain a linear 16-1 point range is the way to go I don't need to use this method in future seasons.

EDIT:

I just made the file for Season 2 with what data we have so far (just 2 weeks) and the swap works fine on the new file. It won't work on the old one for the reason I speculated, but now that I'm just putting in numbers for the point values instead of calling from a different cell, sort works as intended. Thanks for the help!

We have a newcomer to Season play ranks, welcome to ren8585 who makes his/her debut in the top 16 of the November 9th rankings!