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

samN
10 - Fireball

Probably would have been easier without a macro, but i need more practice with them anyways. 

ggruccio
ACE Emeritus
ACE Emeritus

More fun with iterative macros!

LandonG
8 - Asteroid

My solution.

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached

 

Spoiler
God bless multirow
jasperlch
12 - Quasar

Solution attached.

aclaxton
8 - Asteroid

Couldn't get my iterative macro to work properly (glad I signed up for the live training tomorrow), so I ended up just using mulirow formulas.

Spoiler
Week 14.png
michalsicak
7 - Meteor

this brought me back to my previous job, enjoyed this very much. And would've enjoyed my previous job way more with this workflow :)

 

Spoiler
challenge14.png
michalsicak
7 - Meteor

posted challenge 15 by mistake. moving it in the correct thread :)

dsmdavid
11 - Bolide

Went the iterative way

Spoiler
solution 14.png
iterative14.png
SGolnik
11 - Bolide
11 - Bolide

My solution ended up being the same as the first one, but I found the second solution proposed as a good learning opportunity!