Attached is a sample spreadsheet that is used to track team stats in a tournament. The sample has 8 teams in it, but there can be as many as 129 teams in a tournament. Is there a way to populate A and B in the 'stats' sheet with the data from A and B on the 'ethan' sheet without doing it manually? copying the formula down doesn't work because the data is in sequential rows, but it needs to be spread out more on the main sheet.
Bookmarks