💥 How to Use the EXPAND Array Function in Excel 🔥
Excel Quick Tip: EXPAND an array in Excel
For more Excel Shortcut Tips and Tricks, check out our course on Udemy 👉🏻 https://bit.ly/EXCELTIPSANDTRICKS
Learn how to use one of EXCEL's newest array functions to EXPAND an array to compare with a larger array, then VSTACK it and SORT it so that you can run some analysis.
00:00 Start
00:48 What is Expand Array?
01:30 Open Spreadsheet
03:35 Expand Array
04:38 Office Insider
06:23 shift + F3 (Dialogue box)
07:45 Insert details on Dialogue Box
10:15 Stack details
12:10 Sort Function
13:40 Excel Basic Sign Up
15:25 End
Join Our VIP MEMBERSHIP: https://www.myexcel.club
This Excel Training content is 100% free, with no forced subscriptions and nothing hidden behind paywalls. If you value our content, you're welcome to contribute to our efforts by donating here: http://paypal.me/billywigley - Your contributions are greatly appreciated, thank you!
FREE Courses: https://bit.ly/FREE95
Follow Me on Social Media
LinkedIn: https://bit.ly/DGMLinkedInPage
Twitter: / billywigley