excel formula golf skins game

Master Excel: Craft Formula for Golf Skins Game

By Michael Wilson
AD

Ever found yourself trying to calculate golf scores on a boring spreadsheet, wished for a more exciting way to engage with your data? Enter "Golf Skins Game", an exciting twist on traditional golf score tracking, now made more efficient and fun with Excel formulas. Here's how to create and manage a Golf Skins Game in Excel.

First, let's understand the rules. In a typical Golf Skins Game, players compete on each hole (or a set of holes), with the winner taking a 'skin'. If two or more players tie on a hole, the skin rolls over to the next hole, increasing the value. It's a thrilling way to keep score, and now it's easier than ever with Excel.

Setting up the Golf Skins Game in Excel

To begin, create a new Excel workbook and name the sheets accordingly: 'Player Scores', 'Game Log', and 'Skins Tracker'.

AD
Golf Betting Game Payout Calculator, Nassau Skins Wolf Scorecard Tracker, Excel Google Sheets Template, Printable Scorecard Included
Golf Betting Game Payout Calculator, Nassau Skins Wolf Scorecard Tracker, Excel Google Sheets Template, Printable Scorecard Included
Google Sheets Golf Tournament Manager, Live Leaderboard, 8 Games
Google Sheets Golf Tournament Manager, Live Leaderboard, 8 Games
the chip and run formula is shown in this poster, with instructions for how to use it
the chip and run formula is shown in this poster, with instructions for how to use it

On the 'Player Scores' sheet, list players in Column A (A2:A7) and holes in Row 2 (B1:O1). Input players' scores in the respective cells (B2:O7).

Calculating Scores

In Cell B11, enter the following formula to automatically calculate the lowest score on each hole: =MIN(B2:B7). Drag this formula to the right (C11:O11) to apply it to all holes.

Excel Formulas Cheat Sheet | 50+ Essential Excel Functions for Beginners
Excel Formulas Cheat Sheet | 50+ Essential Excel Functions for Beginners
Excel formulas
Excel formulas
the 50 excel formulas are shown in green and white, with text below them
the 50 excel formulas are shown in green and white, with text below them

In Cell A12, enter this formula to find the hole number for each player's lowest score: =MATCH(B11, B$2:B$7, 0). Drag this formula across (B12:O12).

Determining Skin Winners

On the 'Game Log' sheet, list players in Column A (A2:A7) and holes in Row 2 (B1:N1). In Column B, enter this formula to identify the lowest score and skin winner on each hole: =IF(B2=MIN(B2:B7), A2, ""). Drag this formula across (C2:N7).

AD

The cell will display the name of the player who won the skin on that hole (if no winner, the cell will remain empty).

Golf Clash Club Stats Spreadsheet Using a golf clash club stats spreadsheet will help you ass...
Golf Clash Club Stats Spreadsheet Using a golf clash club stats spreadsheet will help you ass...
Skins Golf Scorecard, 2-5 Players, 9-18 Holes, Specials, Carryover, Google Sheets
Skins Golf Scorecard, 2-5 Players, 9-18 Holes, Specials, Carryover, Google Sheets
the top 15 excel formulas for each user in their workflow, including numbers and symbols
the top 15 excel formulas for each user in their workflow, including numbers and symbols
an image of a table with numbers and symbols
an image of a table with numbers and symbols
Golf Skins Game Tracker -- Scorecard with Auto Skins & Carryover, Digital HTML App, No Subscription
Golf Skins Game Tracker -- Scorecard with Auto Skins & Carryover, Digital HTML App, No Subscription
a poster with the words and numbers for formulas in excel, as well as an image
a poster with the words and numbers for formulas in excel, as well as an image

Tracking Skins

On the 'Skins Tracker' sheet, list players in Column A (A2:A7) and holes in Row 2 (B1:N1). To automatically track skins, enter this formula in Cell B2: =IF(COUNTIF($B$2:$B$7, A2)>1, SUMIF($A$2:$B$7, A2, $B$2:$B$7), ""). Drag this formula across (C2:N7) and then down (B3:B7).

This formula will track the cumulative number of skins each player has won through each hole.

AD

Current Skin Value

To track the current skin value (the total value of skins rolled over from previous holes), enter this formula in Cell B8: =SUMPRODUCT(($B$2:$B$7)*(N1>B$2:$B$7)). Drag this formula across (C8:N8) and then down (B9).

a blue and black background with many different types of stickers on the back of it
a blue and black background with many different types of stickers on the back of it

The cell will display the current skin value for each player, increasing every time a skin is rolled over.

And there you have it - a comprehensive, interactive Golf Skins Game tracker in Excel. Now you can focus on improving your game while Excel does the heavy lifting. Next time,try adding a few conditional formatting rules to make your game board even more vibrant. Happy Golfing!

AD
AD