Excel DROP Function: We all know that Microsoft Excel has lots of features for performing mathematical calculations. We can use any of them as per our preferences. On that note, the DROP function is one among them and it helps to remove a specified number of rows and columns from the range of input data set.
Today, we will let you understand the steps involved to use Excel DROP Function in the worksheet using its syntax, and a few practical examples. Get the official version of MS Excel from the following link:
https://www.microsoft.com/en-in/microsoft-365/excel
Definition of DROP Function
- It is one of the built-in functions in Microsoft Excel.
- This function helps to remove a specified number of rows and columns from the input range on your worksheet.
- It can drop the rows and columns from the start or end of the given array.
Syntax
- Here, you will see the syntax of the DROP function.
- To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
- Once you enter the formula, click on the Enter button to get the result.
=DROP (array, [rows], [col])
Argument Explanation:
- array – The input array or range.
- rows – It is an optional one. The number of rows to drop.
- col – [optional] Number of columns to drop.
Examples
Let’s look at some practical examples of the DROP Function and explore how to use it in Microsoft Excel.
- Initially, you have to open your Excel workbook on your PC and launch the worksheet with data.
- example, we have entered the array in the range B3:D6 and we will remove the rows at the end of the array using the DROP function.
- Then, you have to enter the formula in the cell as shown below to get the result. For removing rows at the end of the array, we need to specify the rows using the minus symbol. For example, we specified the row’s argument as -2.
- After entering the formula, you need to click the Enter button to get the output.
- Let’s see another example to make it clear for you. Now we will drop the first two columns from the range. For that, we have to use the following formula.
=DROP(array,,2)
- After entering the formula, you need to click the Enter button to get the output.
Summary
We hope that you can understand the usage of the DROP function in the worksheet with examples from this article. Share your comments in the below section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
Video Tutorial
You can use the following video to know how to apply the DROP function in the Excel spreadsheet.
You may also like these:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Deepak is an Excel enthusiast and data analyst with over 5 years of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!
