Recursive lambda - LAMBDA function to perform binary search algorithms - Advanced Excel Techniques
ADVANCED Excel technique - Recursive Lambda
1. Calculate the number of iterations for a binary search algorithm to reach the search value.
2. Generate an array of those steps with a single function.
I mentioned the Lambda formulas would be available to copy from the comments sections... I am sorry, but YouTube will not allow "ANGLE BRACKETS" in the comments section (the greater than and less than symbols used in the formulas.) I will see if I can put them in the POSTS section on my YT page.
Timecodes:
0:00 - Intro
0:40 - Basic example of recursive lambda
2:00 - See binaryCount lambda in action (Counts the number of iterations required for x in a list of n numbers)
2:36 - See binarySeq lambda in action (lists out each iteration of binary search pattern)
2:55 - Explaining the binaryCount Lambda formula
5:19 - How to paste in the example LAMABDA function in the comments section
5:47 - Explaining the binarySeq Lambda calculation
6:17 - BinarySeq lambda in action again
Music clip used from:
"Reformat" Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 4.0 License
http://creativecommons.org/licenses/b...
Visit our business homepage: https://mycostpro.com
On this page of the site you can watch the video online Recursive lambda - LAMBDA function to perform binary search algorithms - Advanced Excel Techniques with a duration of hours minute second in good quality, which was uploaded by the user Excel 101 28 November 2023, share the link with friends and acquaintances, this video has already been watched 1,257 times on youtube and it was liked by 24 viewers. Enjoy your viewing!
