FUNCTION CATALOGUE / LOOKUP & REFERENCE
TAKE Excel function
Returns a specified number of rows or columns.
Correct sentence to use
Take the first [number] rows from [array].
Modify this query in PlainFormula →Example formula
=TAKE(A2:D100,10)
Returns a portion from the beginning or end.
Syntax
TAKE(array, rows, [columns])
Argument signature: array, rows, [columns]
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.