DROP

DROP(array, rows [,columns])

Returns the array without certain rows or columns.

array	The array from which to drop rows or columns.
rows	The number of rows to drop.
columns	(Optional) The number of columns to exclude.

REMARKS

* This function was added in Excel 2024.
* This function can create a Dynamic Array Formula.
* This function can return cell references
* When rows or columns are not provided or missing, all rows and columns are returned.
* If the absolute value of rows or columns is greater than the number of rows or columns, then all rows or columns are returned.
* If "rows" > 0, then the rows are dropped from the top / start.
* If "rows" < 0, then the rows are dropped from the bottom / end.
* If "rows" = 0, then #VALUE! is returned.
* If "columns" > 0, then the columns are dropped from the left / start
* If "columns" < 0, then the columns are dropped from the right / end.
* If "columns" = 0, then #VALUE! is returned.
* You can use the CHOOSECOLS function to return the array with just a specific number of columns.
* You can use the CHOOSEROWS function to return the array with just a specific number of rows.
* You can use the EXPAND function to return the array expanded or padded to specific dimensions.
* You can use the TAKE function to return the subset of contiguous rows or columns from the start or end of an array.
* This function was first released in March 2022.
* For the Microsoft documentation refer to support.microsoft.com

	A	B	C	D
1	=DROP(B1:D3,1) = {4,5,6 ; 7,8,9}	1	2	3
2	=DROP(B1:D3,-1) = {1,2,3 ; 4,5,6}	4	5	6
3	=DROP(B1:D3,2) = {7,8,9}	7	8	9
4	=DROP(B1:D3,-2) = {1,2,3}
5	=DROP(B1:D3,,1) = {2,3 ; 5,6 ; 8,9}
6	=DROP(B1:D3,,-1) = {1,2 ; 4,5 ; 7,8}
7	=DROP(B1:D3,,2) = {3 ; 6 ; 9}
8	=DROP(B1:D3,,-2) = {1 ; 4 ; 7}
9	=CELL("address", DROP(B1:D3,2,2)) = $C$3

1 - What is the array "B1:D3" after removing 1 row from the top.
2 - What is the array "B1:D3" after removing 1 row from the bottom.
3 - What is the array "B1:D3" after removing 2 rows from the top.
4 - What is the array "B1:D3" after removing 2 rows from the bottom.
5 - What is the array "B1:D3" after removing 1 column from the left.
6 - What is the array "B1:D3" after removing 1 column from the right.
7 - What is the array "B1:D3" after removing 2 columns from the right.
8 - What is the array "B1:D3" after removing 2 columns from the left.
9 - Returning a cell reference.