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 #48: Calculating Distribution Priority

myouree
8 - Asteroid

Solution attached.

aazimh
8 - Asteroid

This was one of those where I probably couldn't explain what I did to someone else, but it works 🙂 

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges

 

Spoiler
This is my solution

atcodedog05_0-1585321180204.png

 

aheikes
8 - Asteroid
Spoiler
Challenge48.JPG
kaianderson
8 - Asteroid

Here's my solution. Like this one!

msam90
7 - Meteor

My best solution.

 

I am still not matching the third questions numbers.

 

Spoiler
msam90_0-1585795351947.png

 

AngelosPachis
16 - Nebula

Challenge #48 solved. I show others using the Running Total tool which was smart. I guess I really like the Multi-Row formula tool 🙂 

 

Spoiler
Annotation 2020-04-02 185416.png
steven4320555
8 - Asteroid

Had to do some try and error with the multirow formula. 

Spoiler
steven4320555_0-1587330608091.png

 

dpencheva
8 - Asteroid

Here is my solution. For the third question I've got slightly different distance but items are correct and in the correct order. ; )

SilviaRox
7 - Meteor

I'm sure this solution is over-complicated, but as it's the first time I try my hand at an Intermediate and Spatial challenge, I'm quite happy I could find an answer to all the 3 questions 🙂

I'll peek at others' replies to learn more elegant solutions !