Feb 24 2023 06:52 PM
I need a formula (I think it should be SMALL(IF)) to create a leaderboard of times from column D, based on the number of players in column B.
In other words, a leaderboard for just the groups of 2, and then separately just for groups of 3 etc.
I've tried =SMALL(IF(B3:B="2", D3:D), 1) but that doesn't work. I've also tried =SMALL(IF(B3:B=H2, D3:D), 1) where H2 =2, that works, but ignores the condition. Gives me the best overall time, instead of the best time for groups of 2.
Any help would be appreciated
Feb 24 2023 11:22 PM
These upper links describes the formula syntax and usage of the RANK function in Microsoft Excel.
Example link:
How to rank based on two columns in Excel?
Supposing there are three columns, one with names, the other two with the first scores and second scores, now you want to rank the names based on the scores in two columns, how can you deal with this problem in Excel? Formula and informations you will find in the overlying link.
Feb 24 2023 11:48 PM
Feb 26 2023 05:22 AM