Another option is to hide the previously used items, as explained he

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

andrewm wrote:
Hi - I am using data validation list to create a list. I would like to
in the same cells use data validation custom with countif to limit
duplicates. what can I do. I do not really want to use vba if I don't
have to.any suggestions and can someone point to me to the right
direction


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html