Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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~