Скачать или смотреть 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