1. P

    Need to calculate Average of first 5 non-zero cells in a ROW

    In this example, each score is entered for only the players that played this week leaving lots of blank cells. A new column is added each week between Column D(Hidden) and E. I did this so the arrays in formulas will automatically update when a column is inserted inside the array. In Column...
  2. V

    Trouble with Import functions

    I have a golf spreadsheet I've been using and want to try and take it to the next level. I want to be able to automatically update players handicaps from a website, specifically www.gam.org On that website you can lookup a players handicap by name or by course. However, once you're in this...
  3. T

    Conditionally Adding Diagonal Border and Fill Color

    I am trying to create a printable golf scorecard. I would like to have the cells for holes where the hole handicap, row 2, are equal to or less than the players handicap, column c, to be yellow with a diagonal border, from lower left to upper right, so that the gross and net scores can be...
  4. M

    Formula for changing a column based on results in another column

    Can someone help with a formula o script - I have present handicaps in column AP - based on whether their present handicap is 16 and over or 16 and below - I need the following to happen based n results in column AU: if a number in column AU is higher than 70 Present handicap over 16 (column...
  5. M

    Calcuating total of last 3 cells if they qualify

    I have a spreadsheet that calculates handicap changes - I would like script (if possible) to do the following: The first step is that the total cell (for each row) picks up the last 3 scores if they qualify A formula will then decide if a handicap change is due. However if a handicap is...
  6. T

    Amend value of a single cell when choosing from multiple options

    Hi everyone, I apologise for the ambiguous title. I am very much a novice at Excel, and am quite unfamiliar with the terminology to use. I belong to a social golf group, and for years we have been manually adjusting our handicaps after each round, so i thought I'd try my hand at automating...
  7. V

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

    Pulling specific data from the web to excel

    Hi guys, I have been using a search function box to pull specific data from a website which up until a few weeks ago has stopped working because the website name has changed and the coding does not work anymore. The website was called (.golflink.com.au) but is now called (.golf.org.au) from...
  9. R

    Golf Handicaps Values

    I have a list of player names that are divided into 5 Flights (A to E). Each Flight is determined by dividing the list of names with associated scores into 20% or less of the total players. Each player has a previously calculated handicap. I need to find the largest handicap value within each...
  10. 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...
  11. J

    Complex IF Statements - Assistance Needed!

    Hi all, I am struggling to find the correct IF statements for the spreadsheet located in the below dropbox link. The issues I am trying to overcome are: 1. Column H (Decrease) - I would like this cell to equal one of the decrease values in cells N4 - N9 based on if the value in Column J...
  12. 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...
  13. 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...
  14. 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...

Watch MrExcel Video

This Week's Hot Topics

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