Excel high-energy function DROP is too strong, adjust the number of rows and columns in the data in a few seconds!

Today I will share with you the new function DROP function in WPS. Using this function, you can easily adjust the number of rows and columns in the data, which is as simple as drinking water!

DROP function introduction

Function: The DROP function can delete rows or columns from the beginning or end of an array.

Syntax: = DROP (array, number of rows, [number of columns])

Interpretation:

Parameter 1: The array is the data area of the array to be deleted.

Parameter 2: The number of rows is the number of rows deleted by row. If it is a positive number, the corresponding number of rows is deleted from top to bottom; if it is a negative number, the corresponding number of rows is deleted from bottom to top.

Parameter 3: The number of columns is the number of columns deleted by column. If it is a positive number, the corresponding number of columns is deleted from left to right; if it is a negative number, the corresponding number of columns is deleted from right to left.

Example 1. Delete the first N rows of data

As shown in the figure below, to delete the first two rows of data in the left table, simply enter the formula in the target cell.