Excel DROP function to remove rows or columns from range or array

When analyzing huge datasets, you may sometimes need to pull only the data without a total row/column, headers, or footers. In earlier Excel versions, you’d have to rely on the good old copy/pasting technique. In Excel 365, we have a special function to dynamically extract the desired part of the array by “dropping” irrelevant data.

This tutorial introduces you to the brand-new Excel 365 function that can drop unwanted rows and columns to return a relevant subset of data.

When analyzing huge datasets, you may sometimes need to pull only the data without a total row/column, headers, or footers. In earlier Excel versions, you’d have to rely on the good old copy/pasting technique. In Excel 365, we have a special function to dynamically extract the desired part of the array by “dropping” irrelevant data.

Leave a Comment

Your email address will not be published.