Challenge #1: Join to Range

[siddharth_28]

Re: Challenge #1: Join to Range

[Elias_Nordlinder]

Weekly Challenge - Join to Range

Spoiler

[BenoitC]

Done ! I used formula tool with multiple conditions + Find And Replace + Summarize

[nravik]

This was fun! 

Spoiler

Spoiler!

[nravik]

This is great @BenoitC !

[Jotigautam]

My solution

[pdave87]

Hi @GeneR and everyone,

I have attached my copy, however I had to refer solution after analyzing my approach i.e. trying to create 'Area' using "if" condition on postal code from input1 but that didn't work. Has any one found same solution with difference approach? i.e. joining to range without using "generate rows"? 

If there is any other approach and I'm guessing there are multiple successful approach then I would be happy learn or specific with 'if' condition would be a good learning on how to expand the 'if' condition on range.

Stay safe and take care!

Regards,

Pratik

[natalie_ruppi]

Spoiler

[Alona_Alagano]

my solution

[marctowler]

Never knew about Generate Rows so this was a good challenge to learn and give it a go

Spoiler