Spread.NET 16 Formula Reference
Formula Functions / Functions T to Z / TAKE
In This Topic
    TAKE
    In This Topic

    The function returns a specified number of contiguous rows or columns from the start or end of an array.

    Syntax

    =TAKE(array, rows,[columns])

    Arguments

    The function has the following arguments:

    Argument

    Description

    array

    Refers to the array from which to take rows or columns.

    rows

    Refers to the number of rows to take, A negative value takes from the end of the array.

    columns

    [Optional] Refers to the number of columns to take. A negative value takes from the end of the array.

    Remarks

    The function returns a #CALC! error to indicate an empty array when either of the row or column is 0.

    Data Types

    The function returns an array, the type of each value in the array depends on the parameter.

    Examples

    Version Available

    This function is available in product version 16.0 or later.

    Note: The TAKE function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.