Recursive lambda - LAMBDA function to perform binary search algorithms - Advanced Excel Techniques

Publicado el: 28 noviembre 2023
en el canal de: Excel 101
1,257
24

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


En esta página del sitio puede ver el video en línea Recursive lambda - LAMBDA function to perform binary search algorithms - Advanced Excel Techniques de Duración hora minuto segunda en buena calidad , que subió el usuario Excel 101 28 noviembre 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,257 veces y le gustó 24 a los espectadores. Disfruta viendo!