Challenge #11: Identify Logical Groups

[cwatters]

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

[EmilyCR]

Enjoyed this one!

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

[arjanloogman]

My solution...

Spoiler

No macros, went the regexmatch route. Lower part is same workflow, but the regexmatch and the other formulas combined into one formula per match.

Regards, Arjan Loogman

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

[Ladarthure]

My solution

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

[EricWe]

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

[jdemeaux]

Basic stuff...

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

[dvsrtns]

My outcome isn't exactly the same but pretty close. I cannot figure out what is causing the difference.

Spoiler

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

[DataHabanero]

Excellent challenge, had a very hard time figuring out how to do the concatenation works. However once I figured out you can cross it with a record ID it was much simpler. Hope this works for everyone!

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

[JWS]

Great Challenge

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

[hbraunius]

My solution attached.

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