Challenge #11: Identify Logical Groups

[DE0413]

Challenge complete - similar solution to others 🙂

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[LordNeilLord]

Solution:

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[A_Twa]

Awesome challenge; I took something of a 'brute force' approach to it.  🙂

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[nick_ceneviva]

Solution Attached

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[KOBoyle]

Solution attached. Similar to others I used a Cartesian join and the FindString function. My stumbling block was getting the concatenated groups, which turned out to be quite simple once I saw that action was available with the Summarize tool.

Ken

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[vjoshi]

I can't stop laughing after knowing solution is this simple. I used so many filters and formulas(to calculate intersections and then excluding it) in the end to get to the answer,

[jamielaird]

Here's my solution.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Natasha]

Solution attached

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[BenMoss]

Here's my solution for this one.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[patrick_digan]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.