TAKE
Returns rows or columns from the start or end of an array.
- Excel: Verified match
- Google Sheets: No equivalent
- Returns: Array
Examples
=TAKE(A1:C5, 2) | A | B | C | |
|---|---|---|---|
| 1 | 10 | 2 | alpha |
| 2 | 20 | 4 | beta |
| 3 | 30 | 6 | gamma |
| 4 | 40 | 8 | delta |
| 5 | 50 | 10 | epsilon |
Result 10
Syntax
TAKE(array, rows, [columns])array- range required
rows- number required
columns- number optional
Errors
#CALC!=TAKE(A1:A3,0)
Related
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.