name list
 

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

name list
 

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

name list
 

Thank you for your help

"Gary''s Student" wrote:

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

name list
 

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

On Thu, 10 Apr 2008 11:37:04 -0700, 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