Array formula: how to join 2 ranges together to form one array?

  • Thread starter Thread starter Rich_84
  • Start date Start date
R

Rich_84

Hi,

I'm familiar with array formulas such as:

{=A1:A3}

But is there a way to join two ranges togther e.g. a formula to join the
ranges A1:A3 and B1:B3 into a single 6*1 sized array? I was thinging along
the lines of:

{=A1:A3,B1:B3}

But it doesn't seem to be what I'm looking for.

Thanks,

Richard
 
Can you explain what it is you're trying to do once you have your array?
 
Check your other post.

Rich_84 said:
Hi,

I'm familiar with array formulas such as:

{=A1:A3}

But is there a way to join two ranges togther e.g. a formula to join the
ranges A1:A3 and B1:B3 into a single 6*1 sized array? I was thinging along
the lines of:

{=A1:A3,B1:B3}

But it doesn't seem to be what I'm looking for.

Thanks,

Richard
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

difficult array formula 1
Array Formula, noncontigous range 1
Transposing Array 4
Prob an easy one: How do i copy a formula EXACTLY as it is 9
Extract Formula to Text 6
Linking cell ranges between rows and columns 1
Conditional formula with text 1
date range table array formula 5

Back
Top