1. Write a recursive function in Excel
2. Realize you could’ve done it with REDUCE
3. Write it with REDUCE
4. Realize you could’ve done it with dynamic arrays
5. Write it with dynamic arrays
6. Realize there’s already a built-in function to do it
7. Use the built-in function
8. 😐
8-Step Process For Writing Recursive Functions in Excel
Comments
One response to “8-Step Process For Writing Recursive Functions in Excel”
-
That’s actually so true that I actually wrote down this tought process before doing any thing crazy, it scares to find out other people have been there too
add to that using MAKEARRAY to bypass nested arrays too
Leave a Reply