Challenge #1: Join to Range

[PeteLuka]

Not an ideal solution for too many ranges, but works

[Linas]

Spoiler

[Billy_Jones]

I'm sure there's probably a better way to categorize those postcodes into the appropriate ranges without having to write out this formula, but it worked for me

[GallagherCiaran]

Went for generate rows which would work for any number of sales reps

[GGailly]

What a fun way to learn new things !  solved today :)

[JPPPP]

Spoiler

[Angelica_Obi]

Here's my solution

Started off going a really weird way but glad I got here in the end

[Keppatawn]

Spoiler

[Fayz]

Output

[JosephAskew]

 Fun little puzzle.