Excludes a specified number of rows or columns from the start or end of an array.
ไวยากรณ์
DROP(array, rows, [columns])อาร์กิวเมนต์
arrayจำเป็น
The array from which to drop rows or columns.
rowsจำเป็น
The number of rows to drop. Use a negative value to drop from the end.
columnsไม่บังคับ
The number of columns to drop. Use a negative value to drop from the end.
The DROP function returns an array with a specified number of rows or columns removed from the start or end. If the argument is positive, rows or columns are dropped from the start; if negative, they are dropped from the end.
=DROP(A1:B3, 1)→A2:B3Removes the first row from the range A1:B3.
=DROP(A1:C3, 0, -1)→A1:B3Removes the last column from the range A1:C3.
Select the target cell
Click on the cell where you want the result to appear.
Enter the formula
Type =DROP( followed by the array and the number of rows or columns you wish to exclude.
Yes, you can provide values for both the rows and columns arguments in the same formula.