DROP Function Explained
The DROP function in Microsoft Excel returns a value from a list of values based on a given position. It takes two arguments: the list of values and the position of the value to be returned. The list of values can be a range of cells, an array constant, or a reference to a range. The position is an integer that represents the position of the value in the list. The first position is 1.
DROP Function Syntax
DROP(array, num_rows, num_columns)
- array: The range of cells to be dropped.
- num_rows: The number of rows to be dropped from the top of the array.
- num_columns: The number of columns to be dropped from the left of the array.