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
Watch video Recursive lambda - LAMBDA function to perform binary search algorithms - Advanced Excel Techniques online without registration, duration hours minute second in high quality. This video was added by user Excel 101 28 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 224 once and liked it 5 people.