Is there a way to create a dynamic list for use with data validation? For
example: if I have a list of 10 players. In A1, the list will display all
players in the list. However, B1 will show only 9 players from the list
(original 10 minus the one selected in A1).

Thank you.