have excel list the results

[LUIS CORDERO]

Hello, i have 14 teams and i'm trying to get excel to list them all t
play each other team once

trying to get excel to figure this out for me
a1= team1
b1=team2
c1=team3
d1=team4
all the way down to team n1=team 14

what else do you need to have on this sheet for excel to figure an
list all games

how would you get excel to do this the simplest way

 

[Jason Morin]

Transpose your list to A1:A14, select B1:N14, insert this
formula, and press <ctrl><enter>:

=IF(ISBLANK(OFFSET($A1,COLUMN()-1,)),"",OFFSET($A$1,COLUMN
()-2,)&" vs. "&OFFSET($A1,COLUMN()-1,))

HTH
Jason
Atlanta, GA