Try this:

={"<16","17-18","19-49",">49"}

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jack Sheet" wrote:

> How do I define an array constant as a name?
> I tried to insert a name as follows
> Name: 2006!AgeRange
> Refers to: ={<16,17-18,19-49,>49}
> and it advised that the syntax was incorrect but was otherwise unhelpful.
> I tried substituting ";" for "," as the element separators but that didn't
> help either.
> Thanks
>
> --
> Return email address is not as DEEP as it appears
>
>
>