TAKE & DROP Dynamic Functions in Microsoft Excel

Discover how to use the dynamic excel functions: TAKE & DROP
Learn how to use the TAKE & DROP functions to filter out rows and columns in tables, and how they can collaborate with other Excel functions.

Link to follow along:

Once opened go to File, Download, Microsoft Excel to gain editing access in Excel!

Follow along the series to learn every relevant excel function that will boost your productivity in Excel!

[sobysonics]

summary: use take to specify what parts of a table you want to extract into another new table; use drop to specify what part of a table you don't want to extract into another new table allowing the others parts to be incorporated
pro: drop and take are dynamic

[terrywhsiu]

I like your video, and btw, any ways to extract certain designated columns from an array?

[iwantmahmoneyback]

Could you attach the excels you use in your videos to practice with you?

[flyingsalmon]

Please check your spelling of countries in your data set before posting. I corrected them in my downloaded version. Thanks for the video.

[ibraheemshahzad]

Too small window used

Should be zoomed because difficult to see

[Ratnakumarwrites]

When you said DROP a LIKE, by any chance you wanted to remove one "LIKE"...???? 😀But I TAKE a LIKE here...