golf

I took over the league this year and was given a CD for a golf program that worked with Windows Caveman so I decided to create my own since it is such a small league of old guys! To establish a handicap for this season I manually enterd 5 scores in Columns I through N, in every row, to get a...

Hi everyone: I have looked through the message boards for solutions to my problem and I don't think I've found anything that quite fits. Here's my challenge... I run a golf league with 32 teams, so I have 16 tee time slots. Because of time constraints, job responsibilities, etc., my teams fall...

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...

Trying to create a spreadsheet to calculate stableford scores for 3 teams of 4 and then a second tab to calculate a head to head skins game for 6 matches. Does anyone have a template or something similar?

I've been unsuccessful trying to figure this out using multiple resources so I'm reaching out here. I'm trying to be make the explanation thorough and apologize if it runs on too long. Sheet 1 has everyones scores by hole who played the last round. The Cells with front 9 scores go from E to...

Needing assistance with calculating the ranking for golf scores bases on total score, and then each hole based on the hole handicap. Here's the current data I'm working with (ignore the highlighted cells): In column W, the lowest score will be ranked 1, so with row 6 being 59, it get's 1...

Is there a way to show skins for each hole? I have provided what I have done so far, but the final step to this sheet and will save me a whole lot of time is if it could calculate the skins for me. There are two options I wouldn't mind using that I have shown as a little bit of an example...

Good Afternoon, I am trying my best to create a golf spreadsheet for a league. I am curious if anyone has a current golf league spreadsheet that contains any of these. I would love the quota spreadsheet, but would take any. I am struggling on excel creating formulas although I have had a great...

Good Afternoon, I am in dire need of help. I am not to savvy with Excel. I have been struggling and seem to find no answers on how to convert someones score to par, to points in the row below. For example in quota point system, its a lot like Stableford, but ones handicap is subtracted from 36...

We have a 32-man golf trip that is split up into 2 teams of 16. We play 4 rounds. I am trying to come up with a schedule where everyone has a different partner all 4 rounds, and everyone will play against different people on the opposing team over the 4 rounds (8 in total), with no overlap or...

Hi guys, I could really appreciate some help tracking some golf matchplay results between me and 3 friends. Each month we play a team competition 2vs2, randomly picked teams, with the lowest score from the team being used. Whichever team has the lowest score wins the hole, if they're the same...

Hi all - thanks in advance. I think this is fairly straightforward with an array formula but can't get it to function. If I have a column that has multiple occurences of a word, and the second column contains either a "n" or a "y", if any of the the occurences contain a "Y" I want the formuala...

I want to highlight the days on my calendar that match my Event list, but I want the different events to have different colors. example: Event List 1. 1/3/2020 - Baseball 2. 1/4/2020 - Football 3. 1/5/2020 - Golf 4. 1/6/2020 - Baseball 5. 1/7/2020 - Baseball 6. 1/8/2020 - Golf I want the...

Can someone please help me? I am trying to use PowerQuery to create a table in Excel of all the golf majors. I wish to extract their dates from the Wikipedia articles for each tournament. For example, from this web address https://en.wikipedia.org/wiki/1895_U.S._Open_(golf) I want the...

Hi all. Newbie here, I'm trying to figure out a formula to randomly choose team matchups for an 8 team golf league. And...I'm completely drawing a blank. Can anyone help me? Thank you! Sandi

new to mrexcel but would like some help putting together a golf league scheduler for a 40 player / 20 team league. 18 total weeks. am new to formulas in excel and a general beginner but use excel daily but not to its full potential. want to learn more. thanks.

Hello, I have a reception Im going to be keeping track of those people who arrive and I need 2 formulas to keep track of how many group of people have arrived, and of those how many of them are getting an award. I'm not sure how to attach my spreadsheet anymore since I've gone to Excel 2016 so...

I have a list of 100 names with associated golf scores/handicaps. I need to develop 5 Flights (A, B, C, D, E) into which players will be placed based on their score/handicap, e.g., players who score par to 10 over par (this is a variable) would be placed into Flight A; Players 11 to ? would be...

Hello, I have data in my Sheet that look like this... <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> 1 2 3 4 5 6 7 alpha 100 1 1 43 22 1 1 bravo 2 2 2 2 2 2 2 charlie 3 3 3 3 3 3 35...

I'm having difficulty with the formula to find the lowest 5 of the last 6 golf scores listed in a column. The scores are auto-populated from another sheet so each cell with a score already has a formula in it. I will also have weeks when someone doesn't play so blank cells are common. My...