Challenge #1: Join to Range

[longyanChen]

hi

[jaeheehwang]

Completed 

[klippard001]

Glad to be jumping back into challenges!

[barxdavid99]

Wanted to start from the beginning. Great challenge!

Révélation

Spoiler

[serranoX]

Completed!

[Archie_bos]

[BhanuTadepalli]

Attached my solution below 

[dougbaron]

Révélation

[danblythe_RSM]

Révélation

I seem to have done it backwards to the solution. Rather than expanding the reference table to include all post codes, I used a formula to add the ranges to the source data. The solutions method works way better if there was more data in the reference table.

This was pretty enjoyable for a 2am challenge, I think I will work my way through the rest of these challenges. 😁

[Simon254]

Enjoyed the challenge and I know these will help me grow my skills. Here is my solution using the Generate Rows Tool.