Not necessarily what you're looking for since this is a non VBA
method, but I have uploaded a file in the Code samples folder of the
Files section of this group, called
'3 games  immediately preceding.xls'
which gives the WIN/LOSS for the previous three games played by the
team in column A, in three columns, on every row.
Ignore #NUM errors, formulae can be filled down/up, but not left/right.
No autofiltering is required. Not very elegant, but can be made so I'm
sure.