Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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