Saturday, June 16, 2012

yogi_Rank By Category With Condition

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #595   Jun 16, 2012     www.energyefficientbuild.com.


user bryan-p said:
Rank by category with condition
Need a formula to list the top 5 players by weight and lift, if reps = 1. 
Only the highest weight by a player can be shown, so the same player can't be listed twice.
Spreadsheet has data sheet coming from a Form. 
Assuming I need an ArrayFormula() with Filter() and Sort() in C5 and C11 in Leaderboard sheet, which has the expected result.
-----------------------------------------------------------------------------------------------------------------
following is a solution to the problem