I have a spreadsheet where I have 57 different teams. Everytime a game is played I enter the team number in the corresponding column (they used to use a "1") but I thought that changing it to the team number so I could be able to sort things easier. I also added a 9 to the first 9 teams so I would be sorting all 2 digit numbers and not have to worry about repeating charaters 1-9. I would like to be able to sort the rows based on combinations of 2-4 teams to see how many times those 2-4 teams have played against each other.
Bookmarks