Learn about the *NEW* Dynamic Array Functions in Excel (Filter, Sort, Unique etc.)
Chandoo
View ChannelAbout
👋 Hello. I make you AWESOME at your work 😎 I make videos on Excel, Power BI & Data Analytics so that you can be awesome at your work. ✅ Excel ~ Power BI ~ SQL ~ Python ~ Interview Prep ✅ New Video Every Week ~ Subscribe 💻📗 My courses Advanced Excel 👉 https://chandoo.org/wp/excel-school-program/ Advanced Power BI 👉 https://chandoo.org/wp/power-bi-course/ Everything 👉 https://chandoo.org/mdac ~ KNOW 😀 About me: https://chandoo.org/wp/about/ What I'm doing now: https://chandoo.org/wp/now/ Stuff I use: https://chandoo.org/wp/about/what-we-use/ FOLLOW 🚶♀️🚶♂️ 🌐 Website - https://chandoo.org/wp/ 📃 FREE Data tips newsletter - https://chandoo.org/wp/subscribe/ 📚 Courses - https://chandoo.org/wp/training-programs/ 📷 Instagram - https://www.instagram.com/chandoo.xlsx/ 💥తెలుగు Telugu Channel - https://www.youtube.com/channel/UCuaf89M0Lt5pmXzaUssXHvw/
Latest Posts
Video Description
Introducing the most game changing feature of Excel since Pivot Tables - Dynamic Arrays. This powerful new feature allows us to write formulas in a cell that can return an entire range of values (as against a single value). In this video, you will get a complete overview of the functions and understand their behaviour thru several examples. For a sample file and more discussion, visit https://chandoo.org/wp/dynamic-array-functions/ The dynamic array functions are, FILTER UNIQUE SORT SORTBY SEQUENCE RANDARRAY Watch next: How to use the Spill # operator in Excel - https://youtu.be/kR6czKY4FEw Detailed video on FILTER Function - https://youtu.be/JuTdj2j-9Kg How to use the new XLOOKUP Function - https://www.youtube.com/watch?v=DDlZXXEI1bU #ExcelDynamicArrayFunctions #NewExcelFunctions #DAFunctions #HowtoUseDynamicArrrays
Upgrade Your iPhone Experience
AI-recommended products based on this video
for Magsafe Car Mount【20 Strong Magnets 】Magnetic Phone Holder for Car Phone Holder Mount Dash【360°】Cell Phone Mount for Car Accessories,Car Mount for iPhone 16 Pro Max 15 14 13 12 Plus MagSafe Cases
Magnetic Wireless Charger for iPhone - 3 in 1 Mag-Safe Charging Station for Multiple Devices Apple - Charger Stand Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus Airpods
4-in-1 Wireless Magnetic Power Bank 10800mAh Portable Charger with iWatch Charger, QC4.0+20W PD Fast Charging USB C Battery Pack for Magsafe, iPhone 16/15/14/13/12 Series, Apple Watch etc. (White)
eazpower for Magsafe Power Bank 10000mAh, Magnetic Battery Pack Wireless, 20W PD Fast Charging, Compact Portable Charger with Built-in Cables and Stand for iPhone 16/15/14/13/12/ Apple Watch/Airpods
soundcore P31i by Anker, Real-Time Adaptive Noise Cancelling, Hi-Res Sound, Translation Earbuds, 50H Playtime, Wireless Earbuds, Bluetooth Earphones, Spatial Audio, Fast Charging, IP55 ClimatePartner certified
![MRGLAS 2025 Upgraded Magsafe Car Mount Vacuum Suction Magnetic Phone Holder Car, 360° Foldable Adjustable Suction Cup Phone Stand [89+LBS Suction & 2800gf Magnetic] for Car Accessories iPhone17/16](https://m.media-amazon.com/images/I/71UbeT7ccLL._AC_UL960_FMwebp_QL65_.jpg)
MRGLAS 2025 Upgraded Magsafe Car Mount Vacuum Suction Magnetic Phone Holder Car, 360° Foldable Adjustable Suction Cup Phone Stand [89+LBS Suction & 2800gf Magnetic] for Car Accessories iPhone17/16
OHLPRO Tablet Car Mount Universal Tablet Holder for Car Windshield Dash Dashboard, 360 Degree Rotation,TPU Suction Gel Stick, for iPad Mini 4/3/2/1Samsung Galaxy Size 7"- 10.5" Tablet Mount
Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc
AINOPE Phone Holder for Car Vent 2025 Gravity Air Vent Car Phone Holder Mount for iPhone 16 Pro Max with Vent Clip Hand Free Cell Phone Car Mount for iPhone 16 Plus Samsung S25 Ultra Car Accesorries
![Spigen Case for Galaxy S25 Case, Rugged Armor MagFit [Fast Wireless Charging] Compatible with MagSafe - Black](https://m.media-amazon.com/images/I/81osE87mFrL._AC_UL960_FMwebp_QL65_.jpg)
Spigen Case for Galaxy S25 Case, Rugged Armor MagFit [Fast Wireless Charging] Compatible with MagSafe - Black
![Vihibii for Samsung Galaxy S25+ Plus Wallet Case with Card Holder (4 Cards) [RFID Blocking] & Slide Camera Cover & Raised Edges Protect Screen, Shockproof Rugged Case for S25+ Plus 6.7" 2025, Black](https://m.media-amazon.com/images/I/71YSDNV+PHL._AC_UL960_FMwebp_QL65_.jpg)
Vihibii for Samsung Galaxy S25+ Plus Wallet Case with Card Holder (4 Cards) [RFID Blocking] & Slide Camera Cover & Raised Edges Protect Screen, Shockproof Rugged Case for S25+ Plus 6.7" 2025, Black
![Vihibii for Samsung Galaxy S25+ Plus Wallet Case with Card Holder (4 Cards) [RFID Blocking] & Slide Camera Cover & Raised Edges Protection, Shockproof Rugged Case for S25+ Plus 6.7" 2025, Hot Pink](https://m.media-amazon.com/images/I/71K-GtDw48L._AC_UL960_FMwebp_QL65_.jpg)
Vihibii for Samsung Galaxy S25+ Plus Wallet Case with Card Holder (4 Cards) [RFID Blocking] & Slide Camera Cover & Raised Edges Protection, Shockproof Rugged Case for S25+ Plus 6.7" 2025, Hot Pink
![Spigen Case for iPhone 16 Pro Max Case, Rugged Armor [MagFit] Compatible with MagSafe - Matte Black](https://m.media-amazon.com/images/I/71Gh0VOQtlL._AC_UL960_FMwebp_QL65_.jpg)
Spigen Case for iPhone 16 Pro Max Case, Rugged Armor [MagFit] Compatible with MagSafe - Matte Black
![Spigen Spigen Tempered Glass Screen Protector [GlasTR EZ FIT] designed for Nintendo Switch 2 (2025) - 2 Pack](https://m.media-amazon.com/images/I/61L0hIGSbYL._AC_UL1500_FMwebp_QL65_.jpg)
Spigen Spigen Tempered Glass Screen Protector [GlasTR EZ FIT] designed for Nintendo Switch 2 (2025) - 2 Pack
SanDisk 64GB 2-Pack Ultra USB 3.0 Flash Drive (2x64GB) - SDCZ48-064G-GAM462, Black
SanDisk Ultra Flair USB 3.0 64GB Flash Drive High Performance up to 150MB/s (SDCZ73-064G-G46)
SanDisk 32GB 3-Pack Cruzer Glide USB 2.0 Flash Drive (3x32GB) - SDCZ60-032G-G46T, Black
