AI Hub / AI posts
AI · 1 min read

TAKE

TAKE function in Excel: Returns contiguous rows or columns from array edge.

November 5, 2026
Excel functions / Lookup & Reference
Lookup & Reference function · Excel

TAKE function

Returns contiguous rows or columns from array edge.

Availability

PlatformStatus
ExcelListed
Google SheetsNot listed
On Google Sheets: use ARRAY_CONSTRAIN. ARRAY_CONSTRAIN keeps the first rows and columns. Taking from the end needs another approach.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.