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