Mental block

  • Thread starter Thread starter Jack Sheet
  • Start date Start date
J

Jack Sheet

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
 
Try this:

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

Does that help?

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

XL2002, WinXP-Pro
 
These values are text and not numbers so you need to use either

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

or

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

Regards,

Peo Sjoblom
 
Thanks Peo, And Ron.
Your solotion worked, but for some reason it did not help me in the end. I
wanted to refer to the named array constant as a source for "pick from list"
in data validation, but it seems not to like it unless you dedicate cells to
the range.

Peo Sjoblom said:
These values are text and not numbers so you need to use either

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

or

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

Regards,

Peo Sjoblom
Click to expand...
 
Back
Top