Forum Discussion
Excel 2016 Formula - skins
Hi,
In your formula you find MIN for all cells in the columns, not only for the cells for which in column C is "y".
If you are on Office365 or 2019 you may use MINIFS as
=AND($C6="y",F6=MINIFS(F$6:F$15,$C$6:$C$15,"y"),COUNTIF(F$6:F$15,F6)=1)
(second sheet attached), if not that could be
=AND($C6="y",F6=AGGREGATE(15,6,1/($C$6:$C$15="y")/(F$6:F$15>0)*F$6:F$15,1),COUNTIF(F$6:F$15,F6)=1)
and it's not necessary to use separate rule for each column, you may apply one rule for entire range.
Thank you so much for your help Sergei. I have one additional problem. For Column I, Player 3 is participating in Skins (c8 is a y) and the score is 3. Player 4 is not participating and also has a 3 in Column I row 9. Player 3 should be the winner and be highlighted. When 2 players have the lowest score and one player has a y in column c and the other player does not, the player with the y in column c is the winner. How do I add that to the formula that you gave me?
Thanks again for all of your help.
Okay, so we shall count with the condition
=AND($C6="y",F6=MINIFS(F$6:F$15,$C$6:$C$15,"y"),COUNTIFS($C$6:$C$15,"y",F$6:F$15,F6)=1)
Updated file is attached
Thank you so much Sergei for the excellent answer. The formula is perfect and I appreciate all your hard work.