How to validate data in already list dropdown validated.

[Rao Ratan Singh]

I m in trouble that in my worksheet range d15:d24 is validated by List
dropdown. But i want to validate that in above mentioned range that product
name of my company should not repeat again.

What should i do to validate double or any other idea for it.

Help me

Thanks in advance

Rao Ratan Singh

 

[Debra Dalgleish]

Perhaps you could hide the used items, as described here:

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

 

[Dave Peterson]

It sounds like Debra Dalgleish has a solution for you:

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