I have been appointed the golf handicap guru for a small group (30+) of
golfers. They have been keeping the handicaps by hand. I NEEDTO LINK 2
cells, C5 (date) & C6 (score) together. Keeping up to 20 scores in a row.
After the 21st score, the oldest needs to drop by date. NEED TO AVERAGE LOW
10 OF 20 SCORES. As new players join, there will be blank cells until they
reach 20 scores.

Row Date C5 D5 E5 F5 etc until W5 i.e. 01/12 01/19 02/02 02/09
etc, etc
Row Score C6 D6 E6 F6 etc until W6 i.e. 85 79 80
81 etc, etc

Would also like to sort row by date left (newest) to right (oldest).

Would anyone help a beginner with the correct formula?

Bob Morris