- Joined
- Sep 1, 2014
- Messages
- 1
- Reaction score
- 0
Hi,
In cell F 5, I would like to get the minimum of the numbers in line 5 (ranking), if the player is included (YES/NO line 2). I have many more players, i.e. colums, so I don't want to use this with multiple if formulas. Any ideas?
Thanks!
1 A B C D E F
2 Include YES YES NO YES
4 Player 1 2 3 4
5 Ranking 5,0 5,3 5,3 5,5
In cell F 5, I would like to get the minimum of the numbers in line 5 (ranking), if the player is included (YES/NO line 2). I have many more players, i.e. colums, so I don't want to use this with multiple if formulas. Any ideas?
Thanks!
1 A B C D E F
2 Include YES YES NO YES
4 Player 1 2 3 4
5 Ranking 5,0 5,3 5,3 5,5