I would like to figure out how to show the last 20 games played in my spikeball league. It is played by 2 players on each team so the two winners are recorded in B and C, while losers are recorded in D and E. I have individual wins, losses, and games totaled, but I am unsure how to calculate the record of the last 20 games played by each player.

I've seen other threads, however I'm having trouble trying to replicate those formulas because their sheets are much more detailed. I cannot link it because I am a new user.

Any help is appreciated!