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,
Смотрите видео TAKE || DROP || Dynamic Range || Alternatives to OFFSET function онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь YouExcel Tutorials 09 Октябрь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 647 раз и оно понравилось 18 людям.