ReferenceFunctionsLookup Functions

DROP

DROP: Removes rows and optional columns from the start or end of an array.

Summary

DROP is the complement of TAKE and returns the remaining spilled subset.

Remarks

Positive counts drop from the start; negative counts drop from the end.
rows is required; columns is optional.
Dropping all rows or columns yields an empty spill.
Invalid source references propagate errors.

Examples

Drop header row

Grid

Cell	Value

Formula

=

Result

Not evaluated yet.

Expected

[["Jan"],["Feb"]]

Drop last column

Grid

Cell	Value

Formula

=

Result

Not evaluated yet.

Expected

[[10,20]]

FAQ

What does a negative drop count mean?

Negative counts drop from the end, so DROP(array,0,-1) removes the last column and keeps the leading columns.

What if DROP removes every row or column?

The result is an empty spill rather than an error when all rows or all columns are removed.

Runtime metadata

Category

Lookup

Signature

DROP(arg1: Range (Range), arg2: Number, arg3?…: Number)

Arity

min 2, max variadic

Arguments

arg1by-ref

Range · Range

arg2

Number · Scalar · coercion NumberLenientText

arg3optional

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/lookup/dynamic.rs

COLUMNS

Returns the number of columns in a reference or array.

FILTER

Filters rows from an array using a Boolean include mask.

On this page

Summary Remarks Examples Related functions FAQ What does a negative drop count mean?What if DROP removes every row or column?Runtime metadata