Basically, I have a list of teams in Excel in a column, and then going across in rows are ratings for those teams each week. Is there a way I can group a team with its ratings from each week, so that if I wanted to find a highest rating for say Week 4, I could use the sort in descending order button and all the values for the team would move with it?
Microsoft Excel - Grouping Cells?
- Thread starter Edishi
- Start date