Forum Discussion
Access Analytic Power Query challenge: Ticket list
Power Query Challenge - Ticket List - Access Analytic Every now and then, I like to try one of Wyn Hopkins PQ challenges, just to make sure I can perform the same task in regular Excel. The prob...
That is a pretty amazing formula. Even the formula to calculate the possible values for a given cell is elegant. I separated that formula out and the concatenated the values to help a manual solution.
I still find recursive formula intensely difficult to set up and test and this one has the two recursive loops to contend with!
I still find recursive formula intensely difficult to set up and test and this one has the two recursive loops to contend with!
I didn't come up with the method of solution. The formula is a pretty direct translation of the linked python code originally from R. I also wondered about applying similar logic to chess puzzles: eight queens, knight's tour, even a simple chess playing program. Hoping someone will rise to the challenge!