DROP Function

Description

Returns the array without certain rows or columns.

NOTE

• The absolute value of drop_rows/cols should be less than the number of columns in the array.

Syntax

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

EXAMPLE

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

RELATED