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 #310: Maintenance Schedule

mithily
8 - Asteroid
Spoiler
interesting and I did it without macros- generate rows and joins and cross tab and dynamic rename
DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2023-09-21 140902.jpg

aaziz2
8 - Asteroid

spoiler.png

DanielG
12 - Quasar

Solved

tristank
11 - Bolide

First challenge in a few months and it is bright and early in the morning so I already know this is a bit over engineered but just happy to arrive to a solution ha!

 

Spoiler
 
Rob-Silk
8 - Asteroid

Solution attached below:

 

Spoiler
challenge_310_RS_screencap.PNG
asultanov
8 - Asteroid
Spoiler
Screenshot 2024-02-22 094552.png
olga_strubbe
11 - Bolide

I grasped the requirements of the challenge, but it was quite a complicated matter to wrangle the data in just the right way to achieve the desired outcome.  I ended up leveraging the approach provided in the solution.  Thank you, @AYXAcademy, for showing just the right set of logical steps to drive the solution. 

Capture.PNG

aatalai
14 - Magnetar

C310

Shaktikdhar
8 - Asteroid

Spoiler

Pic1.jpg