Adjust Golf league Skins Conditional formatting

[Gulfcourse]

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 hole throught for all 18 holes.

The person in ROW 17 has decided not to participate in the skins game.
I no longer wish to include his scores for skins but cannot simply cut the row since all the sheets list the golfers in alphabetical order, and I also use the sheet for points.
Another reason I don't want to cut the row, I need to keep it alphabetical.

This may happen for a few more people, perhaps row 24, so I may as well ask now how to do it since I've come up empty.

Is there a way to edit the formula to ignore certain rows?

Thank you

 

[arun_eagertolearn]

Hi

Please add an index column (with 1s and 0s) towards the end
That would have 1 for the contestants who continue, and 0s for those who drop out

You could create one more sheet (Eg: named 'Dummy'), with values of that sheet being Skin Sheet x index column values

Thus, the Dummy sheet would have 0s for those who have dropped out

The same formulae/conditional formatting could be applied on the new sheet to get the desired results

 

[Gulfcourse]

Hi

Please add an index column (with 1s and 0s) towards the end
That would have 1 for the contestants who continue, and 0s for those who drop out

You could create one more sheet (Eg: named 'Dummy'), with values of that sheet being Skin Sheet x index column values

Thus, the Dummy sheet would have 0s for those who have dropped out

The same formulae/conditional formatting could be applied on the new sheet to get the desired results

Hello, I really appreciate the reply and I know enough just to be dangerous!
I copied the sheet to a new workbook and created an Index in column Y with 1's and 0's.
As instructed, I copied that sheet to a new one called Dummy, but I'm the dummy that doesn't know how to add column Y, to look for only 1's, to the conditional formatting formula.

I got lost when you wrote "with values of that sheet being Skin Sheet x index column values"
this is the current formula:
=AND(C4=MINIFS(C$4:C$36,C$4:C$36,">0"),COUNTIFS(C$4:C$36,C4)=1,-C$1)
Where do I add if column Y = 1?
Thank you!

 

[JGordon11]

=AND(C4=MINIFS(C$4:C$36,C$4:C$36,">0"),COUNTIFS(C$4:C$36,C4)=1,-C$1, $Y4=1)

 

[Gulfcourse]

Thank you, Thank you, Thank you!

 

[arun_eagertolearn]

The method suggested by @JGordon11 is definitely the simplest one