Here is a general method that does not even require a complete list up front.

Say we are entering names in column A starting in A2 and don't want to enter
a name twice.

In Cell B2 enter:
=IF(COUNTIF($A$2:A3,A3)1,"already used","") and copy the formula down the
column.

Now as names are entered in column A, if a duplicate is entered the warning
appears next to it.

--
Gary''s Student - gsnu200778


"Kevin" wrote:

Hi, is there a way to have a list of names that, once you use a name, it is
removed form the list so it can't be used again. I want to assign names to
rooms and not have them repeat. Any ideas? Thanks