Adjust Golf league Skins Conditional formatting

Gulfcourse

New Member
Joined
Nov 5, 2023
Messages
32
Office Version
  1. 365
Platform
  1. Windows
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
 

Attachments

  • Skin_Sheet.jpg
    Skin_Sheet.jpg
    219.2 KB · Views: 32

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,223,397
Messages
6,171,878
Members
452,427
Latest member
samk379

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top