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???
Bookmarks