I am trying to build a schedule that I can test by using functions, maybe VLookup and CountIF combination. Basically the schedule will have about 75 - 100 teams that will play 5 games each. I want to be able to, without doing a CountIF for each team name, get a count of how many games each team has (assuming we have spelled them all the same) and then display what their field number and game time is for each of their 5 games. (sometimes it is 6 games but if I can get help on the one, should be able to create the other).
Thanks,
Paul