I have a worksheet where I input sporting scores for a year. If a player
plays 12 games, he/she will have 12 scores entered on a row. They may miss a
game and have no score entered as below.
G1 G2 G3 G4 G5 G6 G7 G8 G9 G10 G11 G12
20 18 22 30 28 16 17 23 14

What I am trying to do is get the scores of the last 4 games they played.
From the example above the scores would be 16, 17, 23 & 14 from games 8. 9,
10 & 12. I want to then average their best two scores from the last 4 games.