I am trying to create a spreadsheet for a fantasy fotball draft. I have a
validation list with all of the available players.

How do I remove a player's name from the list once they are drafted (picked
from the list)