Alright, attached is my sample worksheet. If you enter "Adam" as a contender to ColumnA, then you'll see the data (number of wins in the match-up) move down with the names in ColumnA, but they don't move to the right to stay paired with the contender names in Row1. That's the issue I'm trying to fix.
Bookmarks