Saturday, July 28, 2012

yogi_Set Up A Leaderboard That Stays Current As Scoreds Are Updated

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #660   Jul 28, 2012

user Yoshiman03 said: (!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