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 #162: Mondays....they're Marvel-ous!

ChrisMelck
8 - Asteroid

The isolation continues...

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges
Adrenaline rush

 

Spoiler
atcodedog05_0-1585925812004.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590026820434.png

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my workflow !

AngelosPachis
16 - Nebula

Not the most elegant of solution but I managed to get the correct number of records 🙂

 

Spoiler
Annotation 2020-06-03 215852.png
deviseetharaman
11 - Bolide
Spoiler
 
deepaprash
8 - Asteroid

My count is different as well but data looks right. 

AnnaMikhaylova
8 - Asteroid

Here's the solution, had an issue with row count as well. Got me stuck for a couple of attempts. Checked out the published solution, and my results seem to be in line, so let this one go.

bjkay30
8 - Asteroid

Still don't feel comfortable with RegEx.  It always takes me way too long to figure it out, and I always end up needing to look at someone else's to figure it out.  The rest was pretty straight forward.

 

But on the plus side, I did learn how to save to a packaged workbook!

 

Spoiler
bjkay30_0-1593527287299.png

 

coracai
8 - Asteroid

My solution~