TAKE || DROP || Dynamic Range || Alternatives to OFFSET function
In this tutorial, you will learn how to use the TAKE and DROP functions as alternatives to the offset function for creating dynamic ranges. Additionally, this tutorial shows how to use these functions for Year-to-Date analysis.
Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Note: Take and Drop functions are available in Microsoft 365 and the latest versions of Excel
📢”… give thanks to Him and praise His name, for the Lord is good and His Love endures forever…” (Psalm 100:4-5) NIV
Content
00:02 Intro
00:41 Take - Top N
02:21 Take - Bottom N
03:04 Drop - Top N
04:46 Drop - Bottom N
05:31 YTD analysis - Take
07:00 YTD analysis - Drop
Thank you!
Connect with me on:
👉Instagram / youexceltutorials
👉Facebook / youexceltutorials
👉Twitter / youexceltutor
👉 TikTok / youexceltutorials
👉LinkedIn / bunmi-sanusi
🎬Check these tutorials:
Excel functions • Excel Functions
Financial analysis • Financial & Data Analysis
#dynamicrange, #msexcel, #youexceltutorials,
Watch video TAKE || DROP || Dynamic Range || Alternatives to OFFSET function online without registration, duration hours minute second in high quality. This video was added by user YouExcel Tutorials 09 October 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 647 once and liked it 18 people.