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

damc
11 - Bolide

No macro solution

jferrone
8 - Asteroid

I had a bit of trouble with getting this to work as an Iterative Macro. There were some errors in my workflow that I was able to fix. It was good practice for the Advanced Certification. 

 

Spoiler
jferrone_0-1609940314643.png
jferrone_1-1609940334180.png

 

 

 

AnnaRa
7 - Meteor

Solution

OnionKnight
8 - Asteroid

This is pretty nice challenge.

BeginnerMindset
8 - Asteroid

Could only manage the non-macro version.  I need to get my head around iterative macros to get the alternative solution.

Tripti_Lal
8 - Asteroid

Hi Community,

 

Please my solution attached below.

Hub119
8 - Asteroid

Solution attached.

Slacker
8 - Asteroid

My Solution

selliott69
7 - Meteor

I ended up having to check the solution since I was trying in vain to use just the multi-row formula and couldn't figure it out.  

 

Cheers,

-Shawn

Tylercram
6 - Meteoroid

Submitting my workflow. I took the non-macro approach.

 

Got to use the multi-row formula tool for the first time which was fun.