Lookup & Reference Function - DROP

Use the new DROP function to remove a section of an existing array into a new location.

The video shows the DROP function in use.

The written calculation is below:

=DROP(B3:D8,3,0)

​In this example, B3:D8 is the array we want to transform into another form.

3 is the number of rows we want to 'drop' from the selected data. In our example, this means we will not include Waylon, Camila or Jesus in our calculation result.

0 is the number of columns we want to 'drop' from the selected data. In this argument we can use the following numbers to 'drop' the following columns:

1 = Drop first name column

2 = Drop first name and last name columns

-1 = Drop age column

-2 = Drop last name and age column