S
SirMichaelGriffin
i have two sheets. on one sheet i have a column of about 100 team
numbers ranging in varying intervals from 1 to 1676. the other sheet
looks like this: (cell columns separated by - )
[team number 6] - [team 6 stat] - [team 6 stat] - [team 6 stat] ...
[team number 1] - [team 1 stat] - [team 1 stat] - [team 1 stat] ...
[team number 4] - [team 4 stat] - [team 4 stat] - [team 4 stat] ...
[team number 6] - [team 6 stat] - [team 6 stat] - [team 6 stat] ...
[team number 2] - [team 2 stat] - [team 2 stat] - [team 2 stat] ...
Note that team 6 appears in two locations. i need to take each team
number from my first sheet and find it in the other sheet with all the
stats so that i can export averages or totals to the sheet with only
the team numbers.
my problem is that i have a list of team numbers, but i don't know
what order they will appear in the stat sheet, because the matchups
are random.
How can i find the team in the stat list and export the stats to the
team list?
numbers ranging in varying intervals from 1 to 1676. the other sheet
looks like this: (cell columns separated by - )
[team number 6] - [team 6 stat] - [team 6 stat] - [team 6 stat] ...
[team number 1] - [team 1 stat] - [team 1 stat] - [team 1 stat] ...
[team number 4] - [team 4 stat] - [team 4 stat] - [team 4 stat] ...
[team number 6] - [team 6 stat] - [team 6 stat] - [team 6 stat] ...
[team number 2] - [team 2 stat] - [team 2 stat] - [team 2 stat] ...
Note that team 6 appears in two locations. i need to take each team
number from my first sheet and find it in the other sheet with all the
stats so that i can export averages or totals to the sheet with only
the team numbers.
my problem is that i have a list of team numbers, but i don't know
what order they will appear in the stat sheet, because the matchups
are random.
How can i find the team in the stat list and export the stats to the
team list?