Hi - I have a roster in which in a range a1:a10, a15:a20 I will be
putting names in.
eg. andrew, charles, abdul, tony. Andrew or Charles, and abdul or
tony can only occur once. how can I do a data validation on this.

ie. andrew or charles can occur only once, abdul or tony can occur
only once in the ranges

A1:A10, A15:A20

thanks

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=380801