name list

K

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
 
G

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.
 
K

Kevin

Thank you for your help

Gary''s Student said:
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.
Click to expand...
 
Top