Challenge #1: Join to Range

[TobiasFitschen]

Enjoy this one :)

Spoiler

 

[perin]

Here is my first challenge.

[TheOC]

Awesome challenge!

[Bluebird_Tim]

One down many more to go!

[JRBeaudry]

thank for the start ! a nice little one if you come from Excel 😁

Spoiler

I was thinking logic from Excel to use a switch from recreate Range group :)

[SJKIM]

It's a bit late, I want to learn it properly ..^^&

[olivier_newman]

good fun 

[mattbov92]

My Solution

[tsrvineel]

Solved using formula, Join and Summarize.

[LucianoGomes]

I did not know the Generate Rows tool, so I transformed the Postal Code to its previous twenty, based on your last two digits, according to the bases (start) of existing ranges.

Nice to know the Generate Rows tool!

Thanks for the challenge.