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