Hi,
First post, as I've come here looking for some answers, but having trawled the site I can't find an answer to this particular query.
I am running this years Winter League for our golf society and want a fairly simple calculation to be automatically updated based on the entry of each weeks scores - at least I thought it would be simple but I've been tying myself in knots in trying to solve it.
The workbook is attached here: Golf Eclectic 1.xlsx
I want to calculate the value in Column Y - the total of the best five stableford scores over the season, but I only want it to calculate the score once 5 rounds have been played by any player (i.e. after week 4 no values will be calculated, but from week 5 onwards it will...) As all players don't play each week I need to ignore the weeks they missed. The data in this example is from last year's league, so is a realistic interpretation of the likely pattern for this year.
I'd also like to automatically highlight the weeks highest score as you'll see I have done manually in columns D, E & F
If anyone could help by applying the formula(e) to the sheet, I'd really appreciate it.
Thanks all![]()
Bookmarks