Prevent duplicates in a Data Validation List

[slam]

I have a column where data is entered via a data validation drop down list that is pulling from =Drivers

How do I also prevent duplicate entries?

Thanks

 

[slam]

Here you go:

zzzSlam3.xls 18kb

http://cjoint.com/?AHEqstbE9ew

You had the the COUNTIF in the "Selected?" column pointing to the wrong range and in the "source" column you had the ROW(...) function pointing to the wrong range.

I also changed the named formula "Drivers" so the drop down doesn't work at all once all the drivers have been selected.

Thank you! Frustrating that I couldn't figure one out on my own, but that works great now!

 

[T. Valko]

Thank you! Frustrating that I couldn't figure one out on my own, but that works great now!

Good deal. Thanks for the feedback!