When I read the information it talks about doing one drop down that opens to ano
ID: 3561889 • Letter: W
Question
When I read the information it talks about doing one drop down that opens to another drop down. Maybe I didn't explain what I'm trying to do. Where hole one is I would like a drop down list with holes 1 thru 18. When I select the hole number in the list I would like it to fill in the other holes from the number I select example select hole number 12, then it would fill in all the holes with the correct par and handicap with 13 next and continue with the last hole being 11 and not 18. I am doing this because when I start at any hole other than number 1 the Low Net shows who won each hole with carryovers, always show the winner of the starting hole as winner on all the holes in front. I'm trying to get this not to happen, because people want to know howw many skins they have won and this messes the total skins won. If you want to try and fix that you can do thatt and I don't have to do this drop down list. If you do this just use initial's where names go and put numberss in for HC. Thanks for any help.!!!!
Explanation / Answer
Having only passing familiarity with a game which has as its principal object to do as little as possible (my last game, decades ago, I shot a 73, and decided that was the best I was ever likely to do, so the heck with the back nine), I don't understand all the jargon, but I think you might be able to do it this way:
In a separate area of the sheet, or on another sheet (which could be hidden), make a table of your holes, pars, and handicaps:
X Y Z
1 Hole Par Handicap
2 1 4 11
3 2 2 2
...
19 18 4 8
Then:
A B C
1 Hole 1 =1 + MOD(B1, 18)
Copy C1 to the right to S1. Change B1 to whatever hole you're starting on.
Enter
A2: Par
A3: Handicap
B2: =VLOOKUP(B1, $X:$Z, 2, FALSE)
B3: =VLOOKUP(B1, $X:$Z, 3, FALSE)
Copy B2:B3 to the right to S2:S3
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.