The SubArray() function is used to create a new array from a partial area of an existing array.

Syntax

SubArray (Data Range, Rows, Columns)

Examples

Example 1. Create an array from part of an existing array

Example 2. Create an array from an existing array using the column headers

Example 1. Create an array from part of an existing array

The parameters for Rows and Columns are both arrays. In this example, the function returns Row 3 and Row 2. The order given in the parameter determines the order of the output. The Columns parameter is not utilised.

In the next example, the function returns only Column 2. The Rows parameter is not utilised.

When both the Rows and Columns parameter is utilised, the intersection of both is returned. In the next, the function returns the intersection of Row 3, Row 2 and Column 2.

SubArray supports the use of column headers as parameter values.