Hello! I'm new to the forum so correct me if I am wrong or in the wrong location.
Basically I want to do a find and replace for football pool spreadsheet. Only thing is I want to find a team name and change the cell related to the points.
Example: NE vs MIA (NE wins but you picked MIA)
A B
1 [16] [MIA]
So I want to search for all MIA and replace all 16s with a zero.
Thank you
Bookmarks