Uploaded March 2024 | Updated September 2026, 2 weeks ago

---

⚡⚡ 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
gist.github.com/wynhopkins/2efdf218ed78be03a0a082ff6a99dad1

⏬Download my file
aasolutions.sharepoint.com/:x:/s/PubliclyAvailableContent/EeB1ik417QhPok8LG0jLm3ABoHoMKkLfTJO02v-shcUkKQ?e=70BdqH


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


Connect with me
wyn.bio.link


( apologies to Tahlia for accidentally missing her name out 😩 )