Try this one. The example is from the righmost 2 columns.


Also, I was curious why the two-year periods were segregated. If that's what's required, then I guess you live with it, but if the idea is to determine bonus eligibility based on two consecutive "4 or better" years, the attached spreadsheet will get you there. Also applied some conditional formatting to highlight the winners and losers (and non-players, by default!).

Have fun!