# Statistics From Golf Scores

Mar 14, 2008

I am creating a workbook to manage golfer scores, teams, winnings, handicap, ect. I am having trouble with the statistics sheet. I Need A Sub To:

1. Column "B" , take the average of the lowest 5 numbers in columns "AB" though "AU"

2. Column "C" , take the average of the lowest 10 numbers in columns "G" through "Z" divided by 0.96

3. Column "D" , take the average of the lowest 10 numbers in columns "AW" through "BP"

this needs to happen for each row where there is a name. (names added daily)

I have included a similar sheet as the one i am working with along with some command buttons typically not included. Should show some of the problems I am having.

## Golf Scores: Average X Lowest Of Last X

Jan 15, 2006

I would like to set up a Excel spreadsheet for golf handicaps where it will use the 4 lowest scores of the last 5 entries. It must be able to work even if there are missed entries (someone didn't show up/blanks ignored). I would like it to work if there are only three scores used at the beginning of the season, but when there are 5 or more scores, use only the 4 lowest scores out of the last 5. I want it to average these scores. The scores would start in column d. The following is an example of scores with an underscore being a blank:

Golfer 1 45,50,42,43,46,37,45,45,46,44
Golfer 2 41,43,42,_,41,_,_,47,42,39
Golfer 3 44,43,45,54,_,45,43,40,42,_

## Golf Scoring But Have Duplicate Scores - Need To Return Unique Name

Jul 28, 2014

I am attempting to put together a golf tournament spreadsheet. I have figured out how to review a list of numbers, find the lowest ten scores and make a list of those scores. Next to that I want to have excel input the name of the player that shot that score. The problem is, a couple of scores match so excel is only returning one of the golfers names. I am trying to have it return the other golfer who scored the same score.

Here is the formula I am using in Column N:
=SMALL(\$L\$2:\$L\$21,1) This runs from 1 thru 10 for the 10 lowest scores.

Here is the formula I am using in Column O:
=INDEX(\$A\$2:\$A\$21,MATCH(1,INDEX((\$L\$2:\$L\$21=\$N2)*ISNA(MATCH(\$A\$2:\$A\$21,N\$2:N2,0)),0),0))

Here is the formula I am using in Column P: (gives same info as column O formula)
=INDEX(\$A\$2:\$A\$21,MATCH(SMALL(\$L\$2:\$L\$21,ROW(N1)),\$L\$2:\$L\$21,0))

Column A = golfers names
Column L = list of all golfers scores
Column N = lowest ten scores in order

Spreadsheet Attached : Golf Excel Score.xlsâ€Ž

## Golf Scoring But Have Duplicate Scores - Return Unique Name

Jul 28, 2014

I am attempting to put together a golf tournament spreadsheet. I have figured out how to review a list of numbers, find the lowest ten scores and make a list of those scores. Next to that I want to have excel input the name of the player that shot that score. The problem is, a couple of scores match so excel is only returning one of the golfers names. I am trying to have it return the other golfer who scored the same score.

Here is the formula I am using in Column N:
=SMALL(\$L\$2:\$L\$21,1) This runs from 1 thru 10 for the 10 lowest scores.

Here is the formula I am using in Column O:
=INDEX(\$A\$2:\$A\$21,MATCH(1,INDEX((\$L\$2:\$L\$21=\$N2)*ISNA(MATCH(\$A\$2:\$A\$21,N\$2:N2,0)),0),0))

Here is the formula I am using in Column P: (gives same info as column O formula)
=INDEX(\$A\$2:\$A\$21,MATCH(SMALL(\$L\$2:\$L\$21,ROW(N1)),\$L\$2:\$L\$21,0))

Column A = golfers names

Column L = list of all golfers scores

Column N = lowest ten scores in order

## Spread Sheet To Get Golf Handicaps Using The Lowest 5 Of Last 6 Scores

Apr 1, 2008

I need a formula to figure the 5 lowest of last 6 sores, since everyone doesn't play every week there would be blank spaces and it needs to just give me the average if they have less than 6 scores!

I have manipulated the formulas until I am blue in the face and cannot get it to work;

## Organizing Statistics (manipulate Team Statistics)

Mar 30, 2009

I want to manipulate team statistics and having a bit of trouble trying to figure out how to do it. I am relatively new to excel and am using Excel 2007.

I have attached the excel file for your reference (the same file).

What I need to do is first find out the team number using the table on first sheet named "Teams". User will enter team name on call B4 of sheet "Team entry" then in cell C4 there should be a formula to find the team number (is beside name on sheet "Teams) and displays it (on C4). Then on cell D4 of the same sheet "Team entry" there should be a formula that displays cell A1 (shows a statistic for that team) of the team sheet. Each team has its own stat sheet named by its team number (easier for me to keep track). So basically D4 should show cell A1 of the sheet that shows stats of the team entered. In addition cell E4 of "Team entry" should display stat2 (of the sheet "stat2")for the team entered.

## Find Top X Scores Out Of 50 Scores?

Aug 17, 2009

There are scores in B1:B10 (10 scores). I want to take the top 8 scores. So I used this formula which works just fine.

=SUM(LARGE(B1:B10,1),LARGE(B1:B10,2),LARGE(B1:B10,3),LARGE(B1:B10,4),LARGE(B1:B10,5),LARGE(B1:B10,6) ,LARGE(B1:B10,7),LARGE(B1:B10,8))

But I'm trying to make the formula a bit more dynamic. Is there anyway to have a set of data in B1:B50 (50 scores will probably be the most) and take the top x scores? X will be set in a separate cell (lets just say A1)?

## Map Scores To Scaled Scores

Feb 13, 2008

I have a raw score for each case. I need to map those raw scores to scale scores. For example, a raw score of 0 to 0.49 maps to a scale score of 120, a raw score of 0.5 to 0.99 maps to a scaled score of 110, etc. There are a total of 13 possible scaled scores (120, 110, 100, ... 20, 10, 0). Is there a way to do this in Excel2003? (Note, if anyone on the list is 'bilingual' (Excel and SPSS), I'm looking for the Excel equivalent of the SPSS command RECODE raw (lo thur .49=120), (.5 thru .99=110), etc. INTO scale.

## Golf Groupings

Jun 4, 2009

i use it to arrange players for every hole during golf tournaments. The present sheet (that i have attached) will allow as few as 2 players per hole. i have been informed that it should not assign less than 3 players per hole. the math in the code needs to be adjusted so that it knows to always start with 3 somes and work up from there. i can do the math on a sheet of paper i just don't know how to code the math . the attached sheet is what a member on the forum previously did for me. i take no credit for it, i am not capable doing what this sheet does for me.

## Golf Calculator

Feb 6, 2009

Not sure if this is do-able but I figured I would try. For a golf league coming up later this year I want to figure out how many Birdies, Pars, Bogies, Dbl. Bogies and Others each (20) golfers have during the season. After each round I would input their scores and I am looking for a program that would look at the score of the hole and the par for the hole and figure out what they got 1 under par = birdie, even par = par, 1 over = bogie, 2 over = dbl bogie and 3 over = other.

I started by creating a simple if statement but it ran out too long and my other issue is adding up the number of birdies, pars..etc for each round. Meaning a golfer can have bogies on hole #1 and #2 and the if statement can take care of that but how would get a total saying the golfer had 2 bogies.

Something like this with the - meaning a column.

birdies Pars bogies dbl bogies others total holes
4 - 5 - 3 - 4 - 4 - 5 - 6 - 5 - 8 1 4 2 1 1 9

I would do this each week and total the number of each to keep a running total at the bottom of each column. We play on the same course each week so the pars for each hole can be hard coded.

## Arrange Golf Teams

Apr 21, 2009

I run a spreadsheet that manages golf tournaments. i have to group
the # of players evenly as possible on each hole once they are entered into the tournament. since the number of players varies from tournament to tournament the math gets complicated trying to get the groupings right. i can do the math on paper but do not know how to code the math in a macro. this would save me a ton of time if someone can figure this out. i have attached a sample .xls that includes all the info i could think of a person needs to see what is going on. If i am asking to much i understand and will remove the thread.

Feb 15, 2008

I am trying to compute the handicap for a golf group. We base our handicaps on the lowest 4 of your most recent 5 rounds. I have no problem selecting the 4 lowest of 5 using the SMALL function. My problem is have the formula select only the most recent 5 rounds. Because everyone doesn't play every day the five most recent scores might be over several weeks and the others might be in the last week.

I am only entering the adjusted score (not hole by hole). The header columns have the date played.

The formula currently shows =SUM(SMALL(\$F9:\$J9,{1,2,3,4}))/4.

## If Function & Golf Analysis

Jul 5, 2008

I have been putting together workbook for my golf analysis.

Against each hole (1-18) I enter in one row which club I used from the tee which could be any of the following: D,3w,5w,1,2,3,4,5,6,7,8,9,w,s.

I also have a row that says whether I have hit the fiarway or not. If hit fairway = 1 if missed = 0.

What I want to be able to do is show the % of times I hit the fairway with each club. This would seem ida for the if function but I'm not quite sure how it would work because the result row is going to need to look at every hole to see if the club used was d,5w,3 etc etc and 'if' so then it will need to look at the row which says 'hit fairway or not' i.e. 1 or 0. This is where I get lost and am not sure if I do need the 'if' function or something else? Perhaps I need additional rows?

## Golf Score Board

Aug 7, 2009

I am organizing a golf scoreboard for my golf tournaments. Basically, this is what I want to do:

I would like to rank the players that are entered by their score, in ascending order. Basically, I want to take the column for "total strokes" and organize the numbers so that it will rank the numbers that are entered. If there are no numbers entered in a specific row, I don't want that "zero" to be ranked in the list. So for example, if I have five golfers but they are spread out over 10 rows, I would still need to have five numbers in the rank: 1,2,3,4, and 5, not 1 to 10, as if it were ranking the rows that have nothing entered in them.

This is how it will look:

Johnson - Strokes : 70 - Rank :1
Williams - Strokes : 75 - Rank : 3
Patterson - Strokes : 72 - Rank : 2

## Scoring To Break Tie (i.e. Golf)

Oct 7, 2006

I couldn't find a solution to where I'm at now, but Derks formula...
= SUMIF(\$J\$5:\$J\$44,J5,\$K\$5:\$K\$44)/COUNTIF(\$J\$5:\$J\$44,J5)

from...
excel formula

...Almost gets what I need, but my data will not always be in a high/low descending order. I'm braindead; I can't think of how to make this formula work.

## Lotto Statistics

Aug 23, 2007

Been searching the archives but not finding my answers. I downloaded historical lottery numbers and want to run statistics on them- just no clue where to start. I guess the 1st and most important thing is to figure out which #s have come up most often out of all of them. I assume it's some sort of COUNT or LOOKUP code- but not sure. I have the #s arranged in a sheet like so ...

## Descriptive Statistics

Jun 27, 2008

want to make a macro to do a 'descriptive statistics data analysis' of column b and put the results in m1 to n18.

basically doing this but in a macro.
add in= tools /data analysis/ descriptive stats

I have recorded it doing this, but it for some reason can't do what it wrote.

## SUMPRODUCT Statistics

Mar 9, 2009

On Sheet1 I have 2 cells one has the date 1-mar-09 and the other has 7-mar-09. I need to find this range on Sheet2 which has all the dates for the year in ColumnA and then total the amounts found in Sheet2!ColumnB for the specified date range. Is this possible without VB?

## Dropdown List With 9 Golf Course Names

Dec 30, 2013

I am building a golf spread sheet with page 1 being where I will input scores, also on this page I have a drop down list with the 9 golf course names. What I have done is I have added 9 sheets with the names of each golf course, on this sheet I have added the scorecard. So what i am wanting to do is, on sheet 1 use a drop list with the name of the course, then choose what tees we are using and let it populate on sheet1 hole 1 thru 18, with the yardage and par for the hole.

## Handicap System For Golf League

Mar 18, 2007

Just starting to use excel and have a problem I hope someone can solve. Trying to set up handicap system for golf league. Column A is players. Column B shows average of last 5 rounds played and rounded to nearest whole number. column C shows the same without rounding. column D and beyond show scores with column D being the most recent. Have this all this working well with one problem. Each week I insert new column D, enter scores, and everything is recalculated. How do I deal with absent players? Is there a way to enter perhaps "A" for absent and excel will know to count the last 5 cells with numerical values only?

## Aggregate Score Sheet For Golf

Jan 31, 2014

I run a golf society and need to set up a golf aggregate sheet that will allow me to enter the players weekly scores and the sheet will then look for the lowest score entered for each player and replace it with their score of this week.

## Golf League Point Counter

Jul 15, 2006

If the number in one cell is larger than the number in another cell then i would need a 2 added to yet another cell.

I the first two cells are equal then I would need to add a 1 to that 3rd cell.

## Pull Some Statistics From A Workbook

Jan 27, 2009

I'm trying to pull some statistics from a workbook I've been sent and am having some trouble working out how to achieve this.

I have a small interface that allows the user to choose a possible answer (drop-down menu) from a questionnaire (Yes, No, Maybe)(cell: C6). On the interface the user also picks the question they wish to see the stats for (cell: C5)

The data I have been sent has been set up with the questions along in row A, and the answers below in each column (the answers run across row A from column G - AH).

So, what I'm basically after is a formula that first looks up the question specified in C5 (I've used HLOOKUP to pull some other data), and then counts how many times the Yes, No or Maybe answers appears in the column where the question data is held.

## Statistics Of Random Numbers

Dec 3, 2009

I have two rows in a sheet with random numbers (1 till 90).

Those numbers in those two rows I change them every 5 minutes with new one still from 1 to 90
I need a "way", in one side of my sheet (lets say in column B) to count how many times a number was repeated after finish my work (example after 2 hour's)

Is that possible with excel 2007?

## Statistics: How To Recode Data

Oct 9, 2002

I have been looking everywhere for this. In SPSS, it is very easy to recode data, but how do you do this in Excel? For example, researchers often "reverse" their questions on surveys with Likert scales to eliminate respondent errors. In those questions, you want 1=5, 2=4, 3=3, 4=2, 5=1. Is there a plug-in or some other formula that is out there?

May 16, 2008

I have a table of contents page. The TOC is updated each time some one opens the sheet (this is a must have based on the requirements). I'm trying to include some statistics next to each item in the TOC. These statistics are on each worksheet and just need to be copied to the TOC.
Now my problem.

The worksheets are NOT keep in alphabetical order, so After the TOC is created a sort is done to put the TOC links in alphabetical order. After the order is set, I need a formula that will read the worksheet name from a cell on the TOC (which is really a hyper link to a worksheet).

If "=Address!" (Where address is the name of one of the sheets) could be replaced with a cell reference that (I think) would do the trick.

My TOC is a MACRO not a cell formula so if this can not be done with a cell formula but can be done through VBA that would be fine.

## Bowling Statistics Formula

Jul 6, 2008

I have running total of bowling scores current & going back from when I first started.

What I’m trying to archive is a formula that will count the most recent 96 scores and still allow me to add new scores each week in keeping the current running total of 96 games.

The statistics are listed from A4:C215 that may have 1 or 2 scores not listed. (missed games)

Each week new statistics will be added in cell A4:C4 anywhere’s of 1-3 games.

Sep 11, 2008

Back to test you with a few problems as I work through a project I'm carrying out, based on past results data of the English Premier League.

I have some of the solutions/formulas I require already, but there are still some gaps to be filled in!

***

the spreadsheet is set out as follows:

Key Columns / Sub-Title (Remarks)

B Date (the date a match was played - the s.sheet is sorted by this column, A>Z)
C Home Team
D Away Team
E Home team goals scored
F Away team goals scored
I-M Indicates via U or O whether the match contained under or over 0.5,1.5,2.5,3.5,4.5 goals
N Points obtained for Home team (i.e. 3 for a win, 1 for a draw, and 0 for a loss)
O Points obtained for Away team (i.e. 3 for a win, 1 for a draw, and 0 for a loss)

There are 381 rows in total for each worksheet (season) - 1 for the titles, and 2-381 for each match played in the season...................

## Economic Statistics Forecast

Mar 3, 2007

I try to predict some macro economic statistics but any attempt till now didn't make sense. the attached file. Note: when i used the FORECAST function the predicted values showed an unlogical drop while there seems to be a positive trend.

## Statistics By Date Range

Apr 1, 2008

I need to record on Sheet 2 how many times enteries in Coloum B on Sheet 1 appear per date range.