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/by/4.0/ Visit our business homepage: https://mycostpro.com