Skip to content
Excel functionNot in Google Sheets

TAKE function in Google Sheets

Google Sheets doesn't have TAKE — here's what does.

Google Sheets bounds a range with ARRAY_CONSTRAIN, or QUERY when you need rows from the end.

What TAKE does in Excel

Returns a specified number of contiguous rows or columns from the start or end of an array

=TAKE(array, rows, [columns])

Convert TAKE formulas to Google Sheets

Before and after, formula by formula.

  1. First 5 rows of a three-column range:

    Excel
    =TAKE(A2:C100, 5)
    Google Sheets
    =ARRAY_CONSTRAIN(A2:C100, 5, 3)

    ARRAY_CONSTRAIN takes explicit row AND column counts.

  2. Last 5 rows:

    Excel
    =TAKE(A2:C100, -5)
    Google Sheets
    =QUERY(A2:C100, "offset " & (ROWS(A2:C100) - 5))

    QUERY's offset clause skips everything before the tail.

Converting more than one formula? The Excel ↔ Sheets translator rewrites whole workbooks and flags every TAKE so none slip through silently.

Browse Excel lookup functions

More conversions to Google Sheets