validation rule

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

Sorry I'll try to explain what I need - in the roster there are two ranges in which a person's name is placed. However in one range their full name is placed and in the other range their initials are placed. there name can only by placed once (either their full name or their initials)
(initials are used in one range as the cells are too small for their full name)

ie.

range 1. A1:A5 - names thus - joe blogs, tom jones
range 2. c10:c20 - initials thus jb , tj

joe blogs and jb are the same person, tom jones and tj are the same person.

thanks

andrewm