K
Kano in PA
I am trying to create a schedule for several teams. Each team has a defined
name (Team1, Team2 etc). I want a spreadsheet something like this:
A1: Week 1 Games
A2: Team1 B2: at Team2
A3: Team3 B3: at Team4
A4: Team5 B4: at Team6 etc.
where the home team displays "at " and the value for Team# in the same cell.
How do I write such a formula?
name (Team1, Team2 etc). I want a spreadsheet something like this:
A1: Week 1 Games
A2: Team1 B2: at Team2
A3: Team3 B3: at Team4
A4: Team5 B4: at Team6 etc.
where the home team displays "at " and the value for Team# in the same cell.
How do I write such a formula?