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.
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
No comments:
Post a Comment