BL84
Member
Hi guys,
In the attached spreadsheet the "red X" marks the columns where I would like the needed data to appear. Rows 17-25. I input Fairways and 1-2-3+ putts manually. All the info from this "Pre" sheet will be transferred to the monthly sheets. Only "April" is ready at this time. The rest will be adjusted as needed. If possible, I need a formula that will encompass GIR, Up/Down, and GIR Putts. Other formulas as needed could be input to blank cells somewhere on the "Pre" sheet. Scores are input in columns b:j, and rows 5-256. I can do what's needed if I have a sheet for every round played, but I don't want to input on 200+ sheets. There is an example of a partial 1 round, 1 sheet in the upper right portion of the "Pre" sheet. The formula for GIR is in the cells M11:U11. Here's an example of what I'd like to be able to do.
Par for hole #1 = 4
Score for hole #1 = 3
Putts for hole #1 = 1
GIR for hole #1 = 2
From that info I know that I hit the GIR, I had 1 GIR putt and there was not an up/down attempt. I can barely handle the formulae in my spreadsheet now, so I know I can't create a formula that includes multiple criteria. My goal here is to input the scores and have as much info automatically appear as possible. Any help would be much appreciated. If I need to clarify anything, please let me know.
Thanks
BL84
In the attached spreadsheet the "red X" marks the columns where I would like the needed data to appear. Rows 17-25. I input Fairways and 1-2-3+ putts manually. All the info from this "Pre" sheet will be transferred to the monthly sheets. Only "April" is ready at this time. The rest will be adjusted as needed. If possible, I need a formula that will encompass GIR, Up/Down, and GIR Putts. Other formulas as needed could be input to blank cells somewhere on the "Pre" sheet. Scores are input in columns b:j, and rows 5-256. I can do what's needed if I have a sheet for every round played, but I don't want to input on 200+ sheets. There is an example of a partial 1 round, 1 sheet in the upper right portion of the "Pre" sheet. The formula for GIR is in the cells M11:U11. Here's an example of what I'd like to be able to do.
Par for hole #1 = 4
Score for hole #1 = 3
Putts for hole #1 = 1
GIR for hole #1 = 2
From that info I know that I hit the GIR, I had 1 GIR putt and there was not an up/down attempt. I can barely handle the formulae in my spreadsheet now, so I know I can't create a formula that includes multiple criteria. My goal here is to input the scores and have as much info automatically appear as possible. Any help would be much appreciated. If I need to clarify anything, please let me know.
Thanks
BL84