Perhaps, if you clearly outline all the rules, someone will be able to
help you with a data validation formula.

andrewm wrote:
> Hi Team,
>
> unfortunately in the roster I have 2 ranges
> say
> the names - andrew can go in a1:a10, charles can go in a15:a20 but not
> both
> also tony can go in a1:10, abdul can go in a15:20, but not
> both
>
> any ideas
>
> andrewm
>
>


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