DROP

Formulas / DROP
Remove a portion of an array

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

Examples

=DROP(A2:C4,2)
The DROP function can be used to remove rows from an array. For example, the formula will remove the first two rows of the array and return the last row of the array.
=DROP(A2:C4,,2)
The DROP function can also be used to remove columns from an array. For example, the formula will remove the first two columns of the array and return the last column of the array.
=DROP(A2:C4,-2)
The DROP function can also be used to remove the last rows of an array. For example, the formula will remove the last two rows of the array and return the first row of the array.
=DROP(A2:C4,2,2)
The DROP function can also be used to remove both rows and columns from an array at the same time. For example, the formula will remove the first two columns and rows of the array and return the remainder of the array.

The DROP function is used to delete rows or columns from an array. It is a useful tool for quickly removing data from a given array.

The DROP function requires at least one argument, and can take three arguments in total. These arguments can be a range or an in-memory array and can be positive or negative numbers.
Using the DROP function removes a subset of the array, with rows and columns being removed depending on the arguments provided.

What does the DROP function do?

The DROP function removes rows or columns from an array.

What happens when the argument for the DROP function is empty?

The DROP function returns a #CALC! error when the argument is empty.

What happens when the argument for the DROP function is too large?

The DROP function returns a #NUM error when the argument is too large.

What else can the DROP function do?

The DROP function can remove headers and footers from a Sourcetable report. It can also only return data in a Sourcetable report.

What other functions work with the DROP function?

The TOROW, TAKE, EXPAND, and TOCOL functions work with the DROP function.