How to Use the Take Function in Excel (With Examples)
The TAKE function, which is currently being rolled out to Microsoft 365 subscribers, returns a specified number of rows or columns from either the start or the end of a range.
In this video I provide several examples to show you how it works, including how to use it with unsorted data
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:00:15 What is the Take Function?
00:00:23 Selecting the Top X rows
00:01:36 Selecting the Bottom X rows
00:02:00 Using TAKE with Unsorted Data
🗒 Notes and Resources
Download a copy of the files used in this video: https://share.getcloudapp.com/QwuLm10P
The formulas that I used in the demos:
=TAKE(Teams,4)
=Take(A2:H21,4)
=Take(Teams,-3)
=TAKE(SORT(Teams1,8,-1),4)
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #functions #take