⚡⚡ 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 )