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