Golf Eclectic League - help with Worksheet

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

Originally Posted by nflsales

=IFERROR(SUM(LARGE(D3:W3,{1,2,3,4,5})),"")

Please Login or Register  to view this content.

Try this and copy towards down

Great! Thanks so much, that worked a treat!

Originally Posted by nflsales

Select D3:W64 and use below formula in conditional format
=D3=MAX(D$3:D$64)

Please Login or Register  to view this content.

Fantastic - easy when shown how...