Example of the LAMBDA(), INDEX(), MOD(), SEQUENCE(), RANDARRAY(), SORT(), DROP(), TAKE() (etc) functions in one formula to shuffle a deck!
Timecodes:
0:00 - Intro
0:06 - Explain use case of a LAMBDA() function
0:58 - Repeat a range N number of times - INDEX(MOD(SEQUENCE(N)))
2:14 - Combine separate formulas into single formula
3:08 - Name Manager -- Make a new LAMBDA() function
4:10 - Replace inputs with LAMBDA variables
4:38 - Testing the finished LAMBDA function
Visit our business homepage: https://mycostpro.com
Download
0 formats
No download links available.
Excel 365 Tutorial: LAMBDA function example - Randomize N number of card decks | NatokHD