In partnership with Experts Exchange.
Among the new functions currently in beta and soon to be released in the 365 editions of Excel are TAKE and DROP, which dynamically duplicate a range of cells. The TAKE function specifies which rows and columns to get and the DROP function specifies which rows and columns not to get. They both eliminate the need to use difficult and complex formulas for these tasks.