want to create a drop-down list in Excel that removes the entry once it is
used. That is, the entries that have not been used remain viewable and
available to the user, those that have been used are not shown in the list.

Anyone ever done this in Excel?