Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #25: Creating Merchant Combos

Waynemk
8 - Asteroid

I think mine is a novel approach. 

 

Spoiler
can you tell i love the multi-row formula tool?
25.JPG
ggruccio
ACE Emeritus
ACE Emeritus

Took several steps to get there....

dsmdavid
11 - Bolide

Learning my way around macros, so trying to use them all the time - I also thought it more logical to have the nulls/empty in the second column...

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Spoiler
challenge_25 - Snip.PNG
LandonG
8 - Asteroid

Solution attached.

jasperlch
12 - Quasar

Solution attached.

msicak
8 - Asteroid

I had to cheat and look into alex's solution for a bit of inspiration (namely, the multi-row, I knew I could use it to solve this). Thanks, and attached my solution - non-scalable and (somewhat) scalable, even if not fully flexible.

 

Spoiler
challenge25.png
jamielaird
14 - Magnetar

Solved with a cartesian join and a bit of filtering:

 

Spoiler
Screen Shot 2017-12-26 at 16.32.39.png
MaxGiegerich
8 - Asteroid

I used a filter expression to most of the heavy lifting here. Took a bit of fiddling but reduced the number of tasks required significantly. 

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed