businessasusual
New Member
- Joined
- Sep 18, 2011
- Messages
- 3
Ultimately I would like to print one spread sheet showing all information for all people.
We have a group of 50 golfers that have the opportunity to play 8 different courses. There are several ways to win:
Sum of 3 lowest gross scores.
Sum of lowest net for the course that you had the 3 lowest gross scores
Sum of putts for the course that you had the 3 lowest gross scores
Do you have a suggestion on how to set this up so I can copy and paste what I need?
I started with Name of 50 golfers down column A. Across the top I have all 8 courses with sub columns underneath (gross, net, putts) (24 columns)
On the next 8 columns I "reprinted" the gross scores so I could use the small function to get the 3 lowest gross scores. (I would hide this information when printing spreadsheet.) This worked, but...I can't get the sum of the net score based on the 3 lowest gross scores. This is my issue!!
Another idea:
Started with same table above. Then I set up a new sheet so that each golfer had their own chart so I could use the small function, and vlookup. But... none of my functions can be copied from golfer to golfer. - This would work, but I don't want to have to do 50 different formulas (one for each golfer).
I would like a suggestion on which functions to use to get this to work. I will also need to resort the first spreadsheet by Lowest 3 scores to determine 1st, 2nd, 3rd...
We have a group of 50 golfers that have the opportunity to play 8 different courses. There are several ways to win:
Sum of 3 lowest gross scores.
Sum of lowest net for the course that you had the 3 lowest gross scores
Sum of putts for the course that you had the 3 lowest gross scores
Do you have a suggestion on how to set this up so I can copy and paste what I need?
I started with Name of 50 golfers down column A. Across the top I have all 8 courses with sub columns underneath (gross, net, putts) (24 columns)
On the next 8 columns I "reprinted" the gross scores so I could use the small function to get the 3 lowest gross scores. (I would hide this information when printing spreadsheet.) This worked, but...I can't get the sum of the net score based on the 3 lowest gross scores. This is my issue!!
Another idea:
Started with same table above. Then I set up a new sheet so that each golfer had their own chart so I could use the small function, and vlookup. But... none of my functions can be copied from golfer to golfer. - This would work, but I don't want to have to do 50 different formulas (one for each golfer).
I would like a suggestion on which functions to use to get this to work. I will also need to resort the first spreadsheet by Lowest 3 scores to determine 1st, 2nd, 3rd...
