community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #1: Join to Range

Asteroid

First time attempting the weekly challenges. There was a good article on the community about using generate rows plus I thought to use the text to columns to split out the ranges. 

Atom

Here is my solution

Highlighted
Meteoroid

Solution attached. Went for a tokenized regex instead of text to columns.

Meteoroid

Following my recent visit to Inspire Europe, i have returned home truly inspired! Challenge 1 complete - i used a formula tool to group the postal codes to regions. I then replicated your solution to better understand the use of alternative tools.

 

Thank you for the fun challenge.

Meteoroid

Here's my solution to Weekly Challenge 1, planning on working my way through as best I can.

Challenge #1: Solution.

Challenge #1: Solution.

Asteroid

My solution

Atom

Not the most efficient solution but it works! Learnt a few bits in this challenge :)

Was an interesting challenge to solve.