Excel 365 Tutorial: LAMBDA function example - Randomize N number of card decks
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
Watch video Excel 365 Tutorial: LAMBDA function example - Randomize N number of card decks online without registration, duration hours minute second in high quality. This video was added by user Excel 101 06 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 82 once and liked it 1 people.