Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution:
🤣🤣🤣- for sure @logdog0411 !!!
I hate how I did this, but I did it.
Woo!
Sometimes we use Alteryx to simplify math.
Other times we do it the opposite way.
Noting that column A is the Fibonacci sequence and applying some series addition we can see that B and C are the n-2th and n-3th terms of same.
Knowing that, we can calculate A directly and B and C from A.
We could go a step further and code a single number that is A*10^12+B*10^6+C and get it done in a single multi-row formula but the coding and decoding would use more tools that we would save on formulas.