Hello everyone, I was wondering if there was a solution to this problem:
I want to have a data validation list that removes names that are already used, the caveat being that it's an employees list and there can obviously be multiple people with the same first or last name. So if there are, for example, four "Bob"s, I'd like to have the name appear in the dropdown until it is selected four times, or two last names of "Williams" so it should be selectable twice, and then is no longer selectable if that makes sense. Thanks for any help.
Sample.xlsx
Bookmarks