i have a sheet of football fixtures and i want to see who a certain team play all season
i.e.
team 1 v team 2
team 3 v team 4
team 2 v team 3
team 4 v team 1
team 1 v team 3
team 2 v team 4
team 2 v team 1
team 4 v team 3
team 3 v team 2
team 1 v team 3
team 3 v team 1
team 4 v team 2
here are the fixtures on one sheet
on another sheet i want this
team 1 versus
team 2 H
team 4 A
team 3 H
team 2 A
team 4 H
team 3 A
can this done, there are more then 4 teams in the sheet
Bookmarks