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 #240: Every Vote Counts!

Romy
7 - Meteor

Very interesting challenge. I used an iterative macro to solve this challenge. But had to manually copy and paste my macro to various sheets to debug it. 

 

Spoiler
2020-11-26 10_32_29-Alteryx Designer x64 - challenge 240 Macro.yxmc.png

 

atcodedog05
22 - Nova
22 - Nova

Existing challenge

 

Spoiler
Workflow:
atcodedog05_0-1606556086009.png

Macro:

atcodedog05_1-1606556117182.png

Cheers and Happy Analyzing 😀

peter_gb
9 - Comet

Loved this iterative macro use case! 

Spoiler
challenge_240_pgb.png

kelly_gilbert
13 - Pulsar

This was great iterative macro practice! This is one of those situations where I really wish we had a way to highlight/upvote specific solutions, because there are a LOT of different ways to make this happen.

 

Outer workflow:

Spoiler
kelly_gilbert_0-1607541246151.png

 

 

Iterative macro:

Spoiler
kelly_gilbert_1-1607541270106.png

 

SgdPackard810
8 - Asteroid

Multi-row formula tools cracked this code for me! However, a lot of ctrl+c, cntrl+v of workstream snippets probably means there's a more elegant solution than mine. Always happy to arrive at the right final answer though!

SgdPackard810
8 - Asteroid

This macro is sick, very well done.

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

 

Spoiler
Weekly_Challenge_240.JPG
BeginnerMindset
8 - Asteroid

Great challenge. I fell into a couple of pitfalls initially so quite frustrating trying to finish it off.  Got there in the end.

danicahui
8 - Asteroid
Spoiler
Challenge 240 2020-11-19.jpg
JoshuaGostick
11 - Bolide

My solution

 

Spoiler
challenge_240_macro.PNG
Spoiler
challenge_240.PNG