array constant

I want to add an array constant as name. Then I wish to use that name in data validation list. Does anyone have solution for this?

Hello All, I am drawing a blank. I need an example of using an array constant with a set of 10 days. I will use the array constant to determine if a date matches any of the dates in the array constant. This is part of an application that I am helping write for a non-profit organization so that...

Hello All: I am looking for a way to create a dynamic array constant which has the value of {1,1,1;2,2,0;3,0,0} in column 3 and {1,1,1,1;2,2,2,0;3,3,0,0;4,0,0,0} in column 4.. and so on and so forth This is where I have reached so far: I was able to figure out that an array formula...

Hello, I have a apparently simple issue which shows lots of resistance in spite of lots of research on array formulas and constant arrays. I have in a1 a date (let s say 12/05/13) and in b1 another date (15/05/13). In cell B3, I want an array composed of all the dates included in that range...

Experts, Is there any way to make an array formula use an array constant by referencing all the value for that array constant from different, single cell? For example, if I have a simple array formula like {=SUM({1,2,3,4}*{1,2,3,4})} (which =30), can I store the array constant in cell A1 so...