Hi,
I've recently taken over a golf syndicate secretary post and have inherited a manual admin system for keeping the weekly scores and updating league positions etc and thought this would be more easily acheived via Excel and I have 3 immediate issues which I'd like your help with if possible:
1. I need a formula that will give me the group average score for the week. Not every player plays each week so the number of scores entered into the row for that week vary so I need a formula that totals the cells with values and give the average for only those cells?
2. This is the same as above but by columns to give individual players average as the year progresses. (Hope that makes sense?)
3. and finally, I need a formula to pick the each players best 10 scores from the year and display them in a second worksheet; here's the rub...I need each of the ten to be picked throughout the year as each week progresses through the year and also to enter each of the ten best into its own cell?
HELP!
If anyone can assist I'd be very grateful.
Thank, Paul B.
Bookmarks