Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAOne of those progress measure challenges. Tried this one ages ago and had no idea how to approach it. Now it was very doable :)
Difficult one.
Dan
Well that was fiddly
Pretty sure i've spent over 10 hours on this! Finally got the results which matches the output answer. Took a lot of brute force accounting for specific cases.
Solution attached. I had a few remaining address exceptions, but got tired of tweaking the formulas. However, I did take the extra step to de-dup the customer list using the Fuzzy Match tool.
Must agree that it was one the most difficult one I have solved until now. Decided to leverage Reg-Ex as I wanted to practice more on these tools.
The solving thrill continues!!!!!!!!!!!!!!!!