Say I have two named ranges,
Is it possible to have another named range,
and define it as the union of the first two named ranges?
The goal would be that if I edited a cell or added a cell for team_a_players, team_a would automatically update.
Here is a demo spreadsheet. Please make a copy and you'll see that I'm trying to use these named ranges for data validation.