⚡⚡ This is a tutorial in Dynamic Array Excel, LET and LAMBDA ⚡⚡

The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

00:00 Introduction
00:46 The Basic formulas in separate columns
03:17 Bringing it together in a single formula using LET
07:36 Naming the formula using LAMBDA
11:05 Storing your LAMBDAS in a GIST


The Formula ( I realised I could AVOID the HSTACK by using SORTBY )

=LET(
SelectedList,B3:B12,
NumberOfItemsToReturn,4,
TAKE(
SORTBY(
SelectedList, RANDARRAY(ROWS(SelectedList))
),
NumberOfItemsToReturn,1
)


My GIST
https://gist.github.com/wynhopkins/2e...

⏬Download my file
https://aasolutions.sharepoint.com/:x...


BOOK
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
https://wyn.bio.link/


( apologies to Tahlia for accidentally missing her name out )