Challenge #11: Identify Logical Groups

[luciebrett]

My solution uses a completely different (simple) approach when compared with the two solutions.

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

[SGriggs]

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

[PrivateStorm]

Completed challenge is attached.

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

[gauravk]

Here is my solution. Was able to run the whole stats in 7.3 secs

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

[Tom_Pilgrem]

Didn't know you could summarise and use a group by to concatenate strings - very useful to know!

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

[mickael_gest]

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.

[arein0]

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

[CaraI]

Definitely could have done this in less tools, but it runs fast, so I am pleased with that.

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

[justynam]

My solution 🙂

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

[JohnJPS]

Old challenge but nonetheless... I used a Dynamic Formula from the Crew Macro Pack, which isn't as fast as hard coding, but was still pretty quick.

Spoiler

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