24 Dynamic array functions in Excel in 10 minutes
All of Microsoft 365's channels now have the full array (get it) of array functions, I go through 24 of them in this video, Excel 2021 has half: All except TEXTSPLIT, TAKE, DROP, EXPAND, as well as VSTACK, CHOOSECOLS, WRAPCOLS, TOCOL and their horizontal equivalents.
I have an equivalent video for Google Sheets here: • Dynamic Arrays 5 best & 5 worst featu... (but since this video G Sheets has added VSTACK, CHOOSECOLS, WRAPCOLS, TOCOL and their horizontal equivalents (only DROP and EXPAND have no equivalents in G Sheets at this time). This video goes through the concept of dynamic arrays on Excel: • Dynamic Arrays 5 best & 5 worst featu...
00:00 - Introduction
00:24 - TEXTSPLIT
00:54 - UNIQUE
01:05 - Handling blanks
01:25 - SORT/SORTBY
02:16 - FILTER
02:52 - TRANSPOSE
03:06 - VSTACK
03:42 - FREQUENCY
04:19 - CHOOSEROWS
04:29 - TAKE
04:50 - DROP
05:19 - CHOOSECOLS
05:43 - HSTACK
06:10 - EXPAND
06:35 - WRAPROWS
06:50 - WRAPCOLS
07:01 - TOCOL
07:20 - TOROW
07:37 - SEQUENCE
07:57 - RANDARRAY
08:18 - STOCKHISTORY
08:56 - MMULT
09:26 - MUNIT
09:52 - MINVERSE
10:04 - Google Sheets equivalents discussion