Monday, February 20, 2012

yogi_Setup A Leaderboard That Automatically Updates As More Stats Are Added

Yogi Anand, D.Eng, P.E.                                      Google Spreadsheet             

user JToy43 said:
Formula for Sports Statistics?
i'm trying to create a leader board for hockey stats that will automatically update when stats are changed, but i have no idea what formula to use. i need it to list the top 3 in each category (names and corresponding value) and to only include cells with values entered. help? picture is where everything is located
following is a solution to the problem