TAKE and DROP are two new Excel functions that can be used to extract data from a dataset.
TAKE function allows you to Extract a specific number of rows or columns from the beginning or end of the data set.
And, the DROP function allows you to extract everything after dropping the specified number of rows or columns from the beginning or end of the data set.
While these functions are useful, in most cases, you will be using them with other Excel functions. I will cover some examples where I have used the TAKE function and DROP function with other functions such as FILTER and SORT
00:00 Intro
00:04 TAKE Function
01:59 DROP Function
03:07 TAKE + CHOOSECOLS
04:33 Using TAKE with SORT Function
06:46 Using TAKE with FILTER Function
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal