Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #660 Jul 28, 2012 www.energyefficientbuild.com.
user Yoshiman03 said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/oL--36yzuB0)
Vlookup with sorting?
Basically I have a table, the table contains a list of names, their scores for 6 weeks (1 week per column) and column for their total score. What I want to do, is have seperately but on the same sheet is a leader board, that will sort and list the players based on their scores.
user Yoshiman03 said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/oL--36yzuB0)
Vlookup with sorting?
Basically I have a table, the table contains a list of names, their scores for 6 weeks (1 week per column) and column for their total score. What I want to do, is have seperately but on the same sheet is a leader board, that will sort and list the players based on their scores.
Here's the table thus far, each of the scores in this sheet actually are a lookup from another sheet within the spreadsheet so its not just the value
---------------------------------------------------------------------------------
following is a solution to the problem
I have laid it out in such a way as to allow adding more weekly data to the right of column L, and more names at the bottom of column F
I have laid it out in such a way as to allow adding more weekly data to the right of column L, and more names at the bottom of column F
No comments:
Post a Comment