Combining a table column with another range into a single array

**theorize99** · 03-25-2012, 05:25 PM

I'm looking for a way to combine two ranges into one array. Specifically, I'd like the array to include a few specific cells (e.g. "A1:A5") plus a table column name (e.g. "table_name[column_name]").

To give you more background, if you need it, I'm trying to use the QUARTILE function. It requires the input to be an array of numbers. Unfortunately, doing something like...

=QUARTILE({table_name[column_name],A1:A5},1)

...doesn't work. It's a weird one, I know. But you guys have suprised me before. Any ideas???

**FDibbins** · 03-25-2012, 06:29 PM

do you have a sample workbook that you could upload? Its much easier to see what you are trying to do that way

**theorize99** · 03-25-2012, 06:56 PM

Sure thing! I'd like to find the quartiles of combination of highlighted cells between both the 2011 and 2012 sheets. I'd like to use the table name (i.e. "tPA_2012") so that as more lines are added throughout the year, I don't have to continually redo the range for in the QUARTILE formula. Thanks!

sample.xlsx