Hello,
I have a sheet, within a file, I'm using to find skins, the lowest individual score on each golf hole, if there is one.
I'm using conditional formatting and the formula:
=AND(C4=MINIFS(C$4:C$36,C$4:C$36,">0"),COUNTIFS(C$4:C$36,C4)=1,-C$1)
to highlight the cell if there is a skin on each...