You can "remove" a selection from the list so that it can't be selected
again.

See this for instructions:

http://contextures.com/xlDataVal03.html

--
Biff
Microsoft Excel MVP


"cele25" wrote in message
...
i need a formula so when if in a drop down menu that selection has already
been taken from another drop down menu i can place a message to say that
the
selection was already used/taken.

thanks
chris