Quote:
Originally Posted by The Game
thanx so used to doing it the other way just typing in a name threw me off.
|
glad you got it..You can also just copy the name in the name column and paste it to the name entry field.
I also have a schedule creator that I created that works similar to this. You can do a season's schedule in just a few hours. As you fill in your matchups, OO auto creates the schedule and fills in random start times. I haven't released it to the public yet as I've got one formula that I just can't figure out how to get it to work...
The formula is basically:
IF the 4th character of a teams abbreviation (BOS
A) is A then vlookup that team to get the away="" team number, else hlookup the opposing team to get the home="" team number.