👇 LET'S CONNECT 👇
https://linktr.ee/excelupnorth
—————————————————————
⏰ Timestamps ⏰
00:00 Intro
00:25 Example 1
01:00 Using the #TAKE function
01:57 Using the SORTBY function
02:50 Using Positive and Negative Numbers
05:49 Example 2
06:36 Using the FILTER function
08:56 Outro
—————————————————————
In this video, we'll explore the TAKE function in #Excel! The TAKE function is a fantastic tool for extracting specific rows and columns from an array of cells.
We'll start with a dataset containing salespeople and their total sales for the year, along with a detailed breakdown of their monthly sales. Our objectives include identifying the top three salespeople by total sales and displaying their monthly sales for the year's first six months. Using the TAKE and SORTBY functions, we'll streamline the data extraction process and present the information effectively.
Afterwards, we'll move on to a dataset containing revenue records by date, where the earliest record is at the top of the dataset, and the most recent record is at the bottom. Using the TAKE and FILTER functions, we'll extract the most recent revenue record based on Region and Product Category criteria to complete our objectives.
#microsoftambassador
Watch video How To Use The TAKE Function To Extract Rows & Columns In Excel | Office 365 online without registration, duration hours minute second in high quality. This video was added by user Excel Up North 21 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,321 once and liked it 18 people.