We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
17 - Castor

Existing challenge

 

Spoiler
Workflow:
atcodedog05_0-1606556086009.png

Macro:

atcodedog05_1-1606556117182.png

Cheers and Happy Analyzing 😀

peter_gb
8 - Asteroid

Loved this iterative macro use case! 

Spoiler
challenge_240_pgb.png

kelly_gilbert
12 - Quasar

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
7 - Meteor

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
7 - Meteor

This macro is sick, very well done.

JosephSerpis
15 - Aurora
15 - Aurora

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