have excel list the results

  • Thread starter Thread starter LUIS CORDERO
  • Start date Start date
L

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
 
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
 
Back
Top