pull down list and single value allowed
 

I have a column I want to prioritize from 1 to 11. I want to have those
values in a pull down list. I also want to only be able to use each value
once, if the same value is used again I need it to use the new one and get
rid of the old one.

Any thoughts?

pull down list and single value allowed
 

Debra Dalgleish shows how to do it he

http://www.contextures.com/xlDataVal03.html

Hope this helps.

Pete

On Jul 2, 5:14*am, s v <s v @discussions.microsoft.com wrote:
I have a column I want to prioritize from 1 to 11. I want to have those
values in a pull down list. I also want to only be able to use each value
once, if the same value is used again I need it to use the new one and get
rid of the old one.

Any thoughts?