- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- making single array from non-contiguous ranges

Subject: | making single array from non-contiguous ranges |

Posted by: | Stonie J (young.bla…@gmail.com) |

Date: | Fri, 18 Jul 2008 |

The TTEST() function in Excel takes an array for its first argument.

The problem is that the array of data I need to enter is not

contiguous. For example, the values I need are in A2:A15 and A30:A40.

Is there some quick and easy way to combine non-contiguous ranges into

a single array? Something like:

TTEST({A2:A15,A30:A40}, B2:B40, 2, 2)

The simple solution is to move the two ranges together, but that will

cause other problems for me. If need be, we can go into what those

problems are, but first I wanted to see if there was an easier

solution. Could a Simple UDF be written? In a form like:

TTEST(MAKE_ARRAY(A2:A15, A30:A40), B2:B40, 2, 2)

Thanks!

- Re: making single array from non-contiguous ranges posted by Bob Phillips on Fri, 18 Jul 2008