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.