How to Use TAKE Function in Excel

Join 300,000+ professionals in our courses: www.xelplus.com/courses/
You're going to love the new TAKE function in Microsoft Excel! It let's you dynamically take the parts of a data set (rows or columns) you need. Basically you can use a function to keep the rows you need and discard the rest. In this video I'll show you how it works.
Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions.
🌍 My Online Excel Courses ► www.xelplus.com/courses/
🎬 LINK to more KZbin Shorts videos: • Shorts (Tips, Tricks &...
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
More resources on my Amazon page: www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: / lgharani
Twitter: / leilagharani
LinkedIn: / leilagharani
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel

[@husky2003]

I think the ladies at this company need to ask for a raise.

[@sachinrv1]

This is insanely useful. Thanks Laila for all your helpful videos. I have learned tons of Excel from you.

[@RishiAnupam]

This is basically the ARRAY_CONSTRAIN function in Google Sheets, but with a shorter and less descriptive name.

[@Dhiyaneshwar_Vlogger_12]

Pretty Excellent Leila Gharani. 🤠😇

[@abdulsaidmkamara7305]

Very similar in a way to the filter function don't you think ?

[@tazguy371]

That’s what I was thinking, as well 👍

[@cheesewizz8134]

Yeah I don’t see the difference

[@shashidharredd1286]

I fall in love for making my life living extra

[@jimgardner5129]

Beautiful!

[@michaelomosebi6374]

I used the INDEX function for something similar a few hours ago. Interesting to know this!

[@mahansor8295]

Thanks Leila

[@asdanjer]

Finally some useful tutorials.

[@tuulistewart5875]

You ae one of the kind!!!

[@flourishwithMJ]

Thank you.❤

[@leomason15]

Thank you for sharing!

[@dougmphilly]

the power of this function is not that its original but that its easy to teach.

[@pcharl01]

You are a blessing and are appreciated.

[@dulipmichael7646]

Thanks for sharing the useful function, another learning today

[@glorykabundi4879]

Best teacher ❤

[@AjayKumar-fd9mv]

Awesome tip, thanks

[@dougmphilly]

anybody doing moving averages will love this.

[@christyamaranathfernando8212]

Thank you for sharing, You are the best

[@it_ispooja]

Amazing, I love the edit of this video. Soo cool👌👏🏼

[@pauldaniel3137]

I loved it❤, thank you 🤩 my expectation satisfied

[@LeilaGharani]

Happy to hear that, Paul!

[@MS-zp7bt]

I need a refresher course for sure

[@nairobi203]

indeed pretty cool. kind of a reduced Offset function..

[@cameliaac]

How's that? I only used Offset to use data from x columns to the left/right or above/below, but its cool to learn something new.

[@tshepomalaka9679]

This is pretty cool actually ! Thank you Leila Gharani

[@LeilaGharani]

My pleasure!

[@MohamedAliSheikh-tk7cp]

Fantastic ❤

[@hemvaidya]

thanks

[@TheUnicleo]

I wish I could have running SQL script on Excel worksheet rather than having too many functions!

[@granadosvm]

I was about to mention that I find very hard to keep up with Excel's new stuff, especially when a company might have backward compatibility issues, and your comment make sooo much sense! A standardized notation like SQL could make things much easier to keep up with them.

[@pankajpundir2323]

Wonderful mam

[@keeriti2594]

Today I first time came to know Thank you

[@sunshine0282]

I love this lady man. Always has some nerdy stuff handy for the us nerds out there😅. Thanks❤!

[@LeilaGharani]

Glad you like it 🤓

[@suyashkumardewangan77]

Awesome

[@ShubhamSharma-ls6hj]

Amazing

[@borstenpinsel]

How does it compare to offset? Offset(sort(range);0;0;3) gives you the top 3 of a list.

[@ryanmorton377]

The OFFSET function is actually a volatile function in Excel. That means it recalculates at any time a change is made anywhere in Excel. The TAKE function is not volatile meaning that it will put less of a burden on your workbook's calculations. Therefore, using TAKE is better than using OFFSET.

[@alotfy3000]

Good

[@M.A.007]

آفرین 👍🏻👏🏻🌹

[@Rice0987]

As always like for top content!🤗

[@LeilaGharani]

Thanks for the like, John!

[@Rice0987]

@@LeilaGharani your videos deserve thousands of like, Leila!😊

[@rotimioladunni7761]

This is very good. I would like to attend your class, if possible

[@SurajKumar-fx3mc]

👍👍👍from INDIA

[@maison-do-nation]

Thank you! BUT - PLEASE START MAKING TUTORIALS HOW YOU MAKE REELS LIKE THIS ONE HERE

[@sdtspv-ruhulaminkhan5211]

Great

[@kylenguyen3301]

Thank you for this video. Just want to ask the way to do function if i want to keep comlumn 1 & 3. Thank you!

[@markngo3618]

Cool

[@shoepm]

वाह!

[@Toolooa]

I want to take the 1st, 3rd & 7th row

[@unknown_i.m]

Will I get this option in 2019 version

[@MJBrown901]

Is there a give function?

[@EldierHerrera]

Similar to Offset, but better, because I guess it works better with filter function.

[@ryanmorton377]

Also better because OFFSET is a volatile function and TAKE is non volatile.

[@LeilaGharani]

👍

[@handsomecaveman]

I don't TAKE advice this video, I'd rather DROP all the rows but the top three values from my array!

[@AI-lover]

How is this different from the CHOOSECOLS and CHOOSEROWS functions?

[@katestan7002]

I used it alteady

[@LeilaGharani]

👍

[@ledhunters]

Could you make a video about comparing 2 tables. Example: one table has 3 columns: product ID, product description and price the other table has 2 columns: product ID and barcode. What is needed is to compere product IDs from first tabel to product IDs from second table and if particular ID is present then copy barcode of that product ID from second to the first table. Thanks

[@LeilaGharani]

Checkout my XLOOKUP and VLOOKUP videos. I think that's what you'll need.

[@manojpawar007]

OMG I was not knowing this despite using Excel for 16 yrs😢

[@silversolver7809]

Don't worry, it's NEW in 365 only-you haven't been asleep all this time :)

[@PoEt121]

🙏

[@muhammadayub9489]

looks like SQL Query

[@LeilaGharani]

👍

[@mwmkhungo]

Wow

[@user-wy9ll7tq8u]

Dear madam, kindly help me to sort this. ColumnA has A,B,A,A and ColumnB has 1,2,3,0. Minimum value of A is 1 and Maximum Value of A is 3. What formulae to be used to find minimum value but we shouldn't consider the value Zero. Required unique value of columnB shouldn't be zero but we need to fetch minimum value.

[@botcontador3286]

why not just use query()?

[@ralphgarcia5956]

How about if i only want 2 columns not rows

[@mathijs9365]

Use case?

[@Wooster77]

Would it be faster to just copy and paste values?

[@handsomecaveman]

Usually, if you're working with a static data source and not planning on making your work reusable next time 'round, yeah.

[@yashankit7167]

in my excel there is no take function then how could I do the work

[@sagarborkar1]

Wow.. nicely demonstrated, never knew about this =Take(), but now it's too late.. I'm already Taken(😍)..

[@umangdbz]

TOPN ?

[@marveliciouscombos]

Alisa Mitchell's getting fk'd there with that 25k

[@hereg3043]

Can you add filter to it?

[@LeilaGharani]

Yes. I'll create a longer form video on the function and cover more variations.

[@daveabc12]

Allisa Mitchel isn't doing very well 😢

[@lykste]

Office 365 only? not available in 2021.. godamnit

[@marceljunioregondi5594]

I guess this is for 365

[@LeilaGharani]

Yes, only in the subscription version.

[@kasztan4ever126]

somehow I red FAKE TAXI lel

[@LeilaGharani]

😁

[@tmsgacct]

I like you!