Challenge #240: Every Vote Counts!

[Romy]

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

[atcodedog05]

Existing challenge

Spoiler

Workflow:

Macro:

Cheers and Happy Analyzing 😀

[peter_gb]

Loved this iterative macro use case! 

Spoiler

 

[kelly_gilbert]

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

Iterative macro:

Spoiler

[SgdPackard810]

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]

This macro is sick, very well done.

[JosephSerpis]

Challenge Completed

Spoiler

[BeginnerMindset]

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

[danicahui]

Spoiler

[JoshuaGostick]

My solution

Spoiler

Spoiler