On Thu, 9 Jun 2005 03:40:04 -0500, andrewm
<andrewm.1qcqac_1118307935.613@excelforum-nospam.com> wrote:

>
>I am doing a roster and would like to know how to do a function to make
>sure cells certain cells have names present
>eg. cells a1 : a5 should have names present - is there a function in
>say a6 that if all cells (a1:a5) have a name present a6 = true, and if
>any cell has no name present a6 = false (or any other text)
>I want this to make sure all cells are filled in with a name
>andrewm

Correction: Data validation cannot "ensure" that a1:a5 contains names; but
could be used to restrict possible entries to TEXT, and also to certain minimum
length of text.

For example, the validation formula:

=and(ISTEXT(A1),len(a1)>2)

would restrict entries to be text and be at least three characters long.


--ron