All possible NBA matchups

Question

Hello. List all possible NBA matchups using all 30 teams. I created a list on Excel of all the 870 ways to make a matchup. (30 x 29 = 870). This contains duplicates... Example: Celtics vs Warriors and Warriors vs Celtics. Same matchup but different order. I do not want the reverse order matchups. How do I remove the duplicated ones in the list.

Answer 1

Jeff,

If you have a contiguous list, try turning your list of team matchups into an Excel Table, bu selecting one cell in your list, and clicking the "Insert" tab and the "Table" button. Once you've done that you can filter on the matchups you do not wish to see and have them all displayed at once. Then simply select and delete them.