hole

  1. V

    VBA Selecting Array Values Between Specified Values.

    Hi, I am stuck on the following problem: I have created a VBA Excel Userform that calculates the max and min hole size for a given bolt size. All calculations etc are contained within the code on the form, I have not and do not want to reference a spreadsheet. I’ve added a Combobox to...
  2. S

    Excel Formula to sum players with lowest winning score

    I am nearing the end of small project for a golf club and need some help. In this spreadsheet teams\players are listed in column “E”. The individual golf holes are listed in Columns F, G, H, I, J, K, L, M, N, P, Q, R, S, T, U, V, W, X Teams\Players participating in the skins game are marked...
  3. VinceF

    Formula to Determine a Golf Skin

    Having trouble, appreciate any assistance. My dilemma is as follows... (if you're a golfer you'll have a better understanding of what I'm trying to accomplish) With some prior assistance I was given a formula on how to determine a "skin" but going forward I now need to differentiate a...
  4. L

    userform code to search a worksheet for a name and date and then populate 18 cells with data

    I have a work book which looks after a weekly golf groups scoring. I have designed a userform which I want to use a combobox to choose a player, then another combobox where I chose a date. Once I have chosen the person and the date I want to input their scores for the 18 holes and once the...
  5. P

    Data output

    Hi. I have created a table (job list) that contains jobs that are assigned to different workers on certain dates. I want to be able to extract a list that I can print off that will act as a daily job sheet. eg date : 10/06/2018. Worker: John Doe job 1 123 nowhere street. U.K...
  6. J

    Vlookup + Hlookup combination

    I am new to the site as of today. :) I am building out an excel for a golf league and I have ran into a lil problem. What I am trying to do is pull in the handicap for each hole. I have succeeded with the formula. But the #1 handicap hole is referencing the vlookup name (which is 5 for the...
  7. 6

    I enjoy building simple excel formulas, but this RANK function "beat" me. Any suggestions?

    I am working on a kinda fun golf spreadsheet. I have 18 holes going across in columns (hole #1 is A1, #2 is B1, etc). Each hole is either a par 3, par 4, or par 5. Each hole has a handicap rating (or a level of difficulty between 1-18 meaning the hole with a 1 handicap is the most difficult...
  8. PivotMeThis

    Chart with a 'theoretical line' based on user input

    I've been asked to create a file that users can add data to which would be depicted on a chart. A brief explanation: This will be used when constructing a drilled shaft. A drilled shaft is a hole (drilled into the ground) that does not have a standard depth or width. As the hole is drilled...
  9. P

    Golf Match Play Calculations

    Hey All, I am in some desperate need of help for a Ryder Cup (Match play) style golf tournament. We are doing a combination Ryder Cup team format over the course of 3 days, 8 players, teams of 2, as well as have an individual component to scoring our Net for a cash prize at the end. I have...
  10. R

    Collecting average values from multiple sheets with multiple conditions

    Hi all, I have multi-sheet excel file where each sheet represents one round of golf hole by hole. Sheet name = Round1 <tbody> <tbody> A B C D E F 1 Hole Mts Score App Club Dist 2 1 349 4 S 6i 158 3 2 480 5 H 7i 150 4 3 212 3 S 9i 122 </tbody> ... </tbody> Sheet name =...
  11. B

    Stableford golf competition

    Hi all I have been pushed into doing a society comp and providing prizes for 1st 2nd and 3rd So I have a list of names in "column A" there handicap in "ColB" followed by 1 to 18 relating to the scores for each hole. each hole has a stroke index and a par for that hole which means if I...
  12. J

    Copying formulas "problem" or not possible?

    I run a golf league and have created an extensive workbook that calculates the players handicaps on the scorecards. The problem I'm having is trying to add additional scorecards (adding rows) with out having to re-write the formulas for each cell. example: In row 18 the players handicap is...
  13. D

    Find the lowest value against multiple criteria

    Hello There! I have browsed this forum many times but this is my first post As a data nerd, i have began to input mine and some friends golf scores into a "Golf Report" to keep track of our progress and to also give some certain facts and stats along the way. I have four sheets...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top