name list

[Kevin]

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

 

[Gary''s Student]

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.

 

[Kevin]

Thank you for your help

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.

 

[Gord Dibben]

How about a DV dropdown list that hides names as they are used?

http://www.contextures.on.ca/xlDataVal03.html


Gord Dibben MS Excel MVP