1. C

    Golf League Scheduling

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

    Adjust Golf league Skins Conditional formatting

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

    Golf Scoring - 1v1 & Stableford

    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?
  4. G

    Skins Game Conditional Formatting

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

    Golf Tournament Score Card Ranking

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

    Formula Help For Skins Game Golf

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

    Quota/Dogfight/Chicago Golf Spreadsheet

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

    Golf Quota Point System Formula Help

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

    Golf Trip Pairings w/ No Repeats

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

    Tough Golf Tracker

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

    Vlookup with multiple occurances, return a "Y" if the value appears at least once

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

    Conditional Formating in Calendar

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

    Golf majors; retreive data from Wikipedia articles

    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 I want the...
  14. N

    8 team Golf Schedule - need formula to choose teams

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

    golf league schedule 20 teams of 40 players

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

    Countif Table

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

    Golf Handicaps

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

    Looking for an Hlookup and Vlookup criss cross combined formula...

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

    Average lowest 5 of last 6 golf scores in a column

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

    Working Calculate Golf Skins Spreadsheet by entering scores

    Newbie on the forum. I have set up a nice spreadsheet to where I can see who has won the hole by using conditional formatting to highlight the cells equal to minimum value, which is located in row 45. I have two questions... 1. How do I UNHIGHLIGHT the cells if there are duplicate lowest...

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