Between the Sheets — Excel podcast episode 26: Dynamically collecting data with the TAKE and DROP functions.

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.

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Now certified in AI Ethics

Just earned my third AI certification: AI+ Ethics, from AI Certs. Now offering training in ethics issues, including transparency, accountability, privacy, mitigating bias and compliance

Earned another AI certification

I just earned the AI+ Executive certification from AI Certs. This is to assist and train companies in developing AI strategies, governance and risk management,

Get in touch

AI Workshop Inquiry/Booking