Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

JoshuaGostick
11 - Bolide

Went for the non-macro route.

Spoiler
challenge_14.PNG
BenMoss
ACE Emeritus
ACE Emeritus

Didn't feel the need to complicate it with macros! TOOLNAMEHERE FTW!

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 14 is done!

Spoiler
challenge 14 JMS solution.PNGchallenge 14 JMS solution formula.PNG
hanykowska
11 - Bolide

Finally, done

JacobR77
8 - Asteroid

Not quite an answer to this challenge, but if anyone wants to learn a little about iterative macros, I've attached a packaged workflow that makes use of them.

 

 

IJReed
8 - Asteroid

👍

hugolees
7 - Meteor
 
princejindal
9 - Comet

Very interesting challenge, thank you!

HuwHallam
8 - Asteroid

Got to an answer using the multi-row formula tool. I tried sooooo hard to craft an iterative macro for it, but just couldn't get my head around how (I'm new to them). Time to look at what others have done and learn! :)

alyssa_sedai
8 - Asteroid

Here's what I got