Forum Discussion
Help creating a conditional leaderboard
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, ...
I don't think this works in my case. I'm building a database with new data coming in every day (hence B3:B, as there's new info in B regularly). I currently have a database of 60 results. I don't want to find the rank of an individual result, I want excel to find the top 10 results, of a specific group size.
From what I read about rank, I don't think that achieves it.
Does this make sense?
From what I read about rank, I don't think that achieves it.
Does this make sense?
I have found a solution. Not that I completely understand it but it works.
=ARRAY_CONSTRAIN(ARRAYFORMULA(SMALL(IF($B$3:$B=$H44,$D$3:$D),1)), 1, 1)
B3:B is the group size
H44 = "2"
D3:D is the times
And the first of the three 1's at the end is for the first (smallest times). Change that to 2 for the second smallest time, etc.
=ARRAY_CONSTRAIN(ARRAYFORMULA(SMALL(IF($B$3:$B=$H44,$D$3:$D),1)), 1, 1)
B3:B is the group size
H44 = "2"
D3:D is the times
And the first of the three 1's at the end is for the first (smallest times). Change that to 2 for the second smallest time, etc.