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
Watch video 24 Dynamic array functions in Excel in 10 minutes online without registration, duration hours minute second in high quality. This video was added by user David Benaim 28 February 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,635 once and liked it 91 people.