Revised Golf scoring

[Rock5150]

I posted yesterday a game I needed help calculating winnings but to keep it simple, I'll just as the following. I attached sample scores. A Rabbit is getting a PAR. A squirrel is getting a birdie. However, how can I adjust the formulas so that if someone doesn't par a hole, but the lowest score is a bogey so I can label that "BOGEY" again if bogey is the lowest score for the hole and for an eagle, maybe call that "EAGLE". I would ope a double bogey (two strokes above par) isn't the lowest score but I guess while I'm at it, maybe include that in the formula. I'm fine with the multiple rabbit and squirrel showing as I can visually see those.

For cell c8, if the score was a "2" how can I label that "EAGLE" and for cell F5 if the score was say a "5" assuming other scores stay the same how can I label that "BOGEY" . The formula I used in B17 and copied is =IF(B5>B$3,"",IF(B5=B$3,"Rabbit",IF(B5<B$3,"Squirrel")))

Also any idea how I can put a conditional formatting to identify the lowest number? So if a rabbit and squirrel are in the same column, pick squirrel. I put in green the people who would "win" the hole.

HD Ham and Egg spreadsheet for HD Invitational May 2024 everyone has everyone.xlsx
	M
9	4
Sheet1

 

[Fluff]

Duplicate to: Golf scoring game

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.