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 #14: Warehouse Distribution

elliemason
8 - Asteroid
 
nnilz
8 - Asteroid

Solution posted. Pay attention to the multi-row formula

harrycooney
7 - Meteor
 
catherineduffy
8 - Asteroid

My solution - didn't go down the macro route

jssandom
8 - Asteroid

Enjoyed this one

Suzu
9 - Comet

Here is my solution.

jbranaum
8 - Asteroid

Here is my solution.

 

I found this problem to be pretty straightforward without going the macro route.  I'm not the greatest at macros in general yet so I figured this to be the path of least resistance for me.

 

At least currently while I practice more at macro configuration :)

 

Thanks!

 

 

archietao
8 - Asteroid

Worked it out without a Macro. Now will try to solve it with a Macro. 

Karam
8 - Asteroid

My take on it :)

 

 

Spoiler
Challenge 14.PNG
NilsM
8 - Asteroid

My solution:

Spoiler
AlteryxChallenge14_1.PNGAlteryxChallenge14_2.PNG