View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic[_2_] Domenic[_2_] is offline
external usenet poster
 
Posts: 265
Default Array formula: how to join 2 ranges together to form one array?

Can you explain what it is you're trying to do once you have your array?

In article ,
Rich_84 wrote:

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