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

Illya
8 - Asteroid

My solution.

Without using a macro not counting the error checking macro that I found somewhere, I forget where.

Sorry for not crediting the original author of the error checking macro.

If was originally yours thank you it's pretty sweet and I plan to use it extensively PM me and I will credit you in future.

sgrabish1
8 - Asteroid

Thanks for practice exercise

Nicholas_Bignell
8 - Asteroid

Another great challenge

gracec97
8 - Asteroid
Spoiler
Challenge 14.JPG
KolsumaAktar
8 - Asteroid

Solutions attached

JamesCameron
8 - Asteroid

My efforts, with/without iterative macro

 

Spoiler
No Macro
JamesCameron_0-1573803487215.png


With Macro

JamesCameron_1-1573803536713.png

Macro

JamesCameron_2-1573803574116.png
Laszlo_D
8 - Asteroid

The Macro: 

image.png

And the workflow:

image.png

mheinze
Alteryx
Alteryx

Used a couple of multi-row formulas. 

Chantelb
9 - Comet
Spoiler
Chantelbbr_0-1574747214120.png

 

sarahjohnson
8 - Asteroid
Spoiler
sarahjohnson_0-1574873192531.png