TAKE Function

Description

Returns the array with certain rows or columns.

NOTE

• The absolute value of rows/cols parameters shouldn’t be greater than the number of rows/columns in the array.

Syntax

Copied!=TAKE(array, [rows], [col])
=TAKE(array, [rows], [col])

EXAMPLE

Copied!//𝘵𝘢𝘬𝘦 𝘧𝘪𝘳𝘴𝘵 𝘵𝘩𝘳𝘦𝘦 𝘤𝘰𝘭𝘶𝘮𝘯𝘴
=TAKE(A1:E10, , 3)
//𝘵𝘢𝘬𝘦 𝘭𝘢𝘴𝘵 𝘵𝘩𝘳𝘦𝘦 𝘳𝘰𝘸𝘴
=TAKE(A1:E10, -3)
//𝘵𝘢𝘬𝘦 𝘭𝘢𝘴𝘵 𝘳𝘰𝘸 𝘢𝘯𝘥 𝘭𝘢𝘴𝘵 𝘤𝘰𝘭𝘶𝘮𝘯
=TAKE(A1:E10, -1, -1)
//𝘵𝘢𝘬𝘦 𝘧𝘪𝘳𝘴𝘵 𝘢𝘯𝘥 𝘭𝘢𝘴𝘵 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘵𝘩𝘦𝘯 𝘤𝘰𝘭𝘭𝘢𝘱𝘴𝘦 𝘰𝘶𝘵𝘱𝘶𝘵 𝘢𝘳𝘳𝘢𝘺
=TAKE(A1:E10, {1;-1})
//𝘵𝘢𝘬𝘦 𝘧𝘪𝘳𝘴𝘵 𝘵𝘩𝘳𝘦𝘦 𝘤𝘰𝘭𝘶𝘮𝘯𝘴
=TAKE(A1:E10, , 3)
//𝘵𝘢𝘬𝘦 𝘭𝘢𝘴𝘵 𝘵𝘩𝘳𝘦𝘦 𝘳𝘰𝘸𝘴
=TAKE(A1:E10, -3)
//𝘵𝘢𝘬𝘦 𝘭𝘢𝘴𝘵 𝘳𝘰𝘸 𝘢𝘯𝘥 𝘭𝘢𝘴𝘵 𝘤𝘰𝘭𝘶𝘮𝘯
=TAKE(A1:E10, -1, -1)
//𝘵𝘢𝘬𝘦 𝘧𝘪𝘳𝘴𝘵 𝘢𝘯𝘥 𝘭𝘢𝘴𝘵 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘵𝘩𝘦𝘯 𝘤𝘰𝘭𝘭𝘢𝘱𝘴𝘦 𝘰𝘶𝘵𝘱𝘶𝘵 𝘢𝘳𝘳𝘢𝘺
=TAKE(A1:E10, {1;-1})

RELATED