Extract part of a range with TAKE and DROP | Excel MVP Secrets with Cristiano Galvão — Part 7
If you have a large dataset, you'll often want to focus on a specific portion to make it easier to analyse.
Returning a formula-based subset hasn't always been easy in Excel; however, the introduction of the TAKE and DROP functions last year has made it a breeze.
In the final episode of a seven-part series, Cristiano Galvao shows you how to include and exclude rows and columns from a range and highlights the flexibility of these functions.
𝘛𝘩𝘪𝘴 𝘴𝘦𝘨𝘮𝘦𝘯𝘵 𝘪𝘴 𝘱𝘢𝘳𝘵 𝘰𝘧 𝘊𝘳𝘪𝘴𝘵𝘪𝘢𝘯𝘰 𝘎𝘢𝘭𝘷ã𝘰'𝘴 '𝘗𝘰𝘸𝘦𝘳 𝘶𝘱 𝘸𝘪𝘵𝘩 10 𝘕𝘌𝘞 𝘌𝘹𝘤𝘦𝘭 𝘧𝘶𝘯𝘤𝘵𝘪𝘰𝘯𝘴' 𝘭𝘪𝘷𝘦 𝘴𝘦𝘴𝘴𝘪𝘰𝘯, 𝘳𝘦𝘤𝘰𝘳𝘥𝘦𝘥 𝘢𝘵 𝘎𝘭𝘰𝘣𝘢𝘭 𝘌𝘹𝘤𝘦𝘭 𝘚𝘶𝘮𝘮𝘪𝘵 2023.
That's a wrap!
If you've missed any of the previous episodes, check them out so you can discover a range of other new productivity-powering functions:
🎥 Part 1 — Create custom functions with LAMBDA: https://lnkd.in/ewNcFrby
🎥 Part 2 — Introducing the Advanced Formula Environment: https://lnkd.in/e2sEKSUQ
🎥 Part 3 — Extract text using TEXTBEFORE & TEXTAFTER: https://lnkd.in/e47ij3bA
🎥 Part 4 — Split cell values with TEXTSPLIT: https://lnkd.in/e8W32yuD
🎥 Part 5 — Shaping arrays with WRAPCOLS and WRAPROWS: https://lnkd.in/eeRmxFV5
🎥 Part 6 — Return specific columns or rows from a range: https://lnkd.in/ePFzCnT4
#excel #microsoftexcel #globalexcelsummit
---
The Global Excel Summit is the world's largest gathering of Microsoft Excel users and experts.
Learn more at https://globalexcelsummit.com/.
Find us on:
👔 LinkedIn: / global-excel-summit
🐤 Twitter: / excelsummit
🟦 Facebook: / globalexcelsummit
📸 Instagram: / globalexcelsummit
🤳 TikTok: / globalexcelsummit