Challenge #11: Identify Logical Groups

[mceleavey]

I don't know why this gave me so much trouble, it turned out to be fairly straightforward. I blame age.

Spoiler

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

[bkclaw113]

I appended the search terms to field6 to force a product join and then could simply use a formula with contains to find the search words.

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

[DiegoParker]

Sure this is not how it was meant to be but reached the solution nonetheless.

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

[Awesomeville]

Non-dynamic solution. But it still works.

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

[pfredin]

Here is my solution.

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

[mgcarrenard]

My solution

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

[cgoodman3]

Batch macro approach for me. Took a little bit longer because for some reason a batch macro only shows one result unless you add a browse tool on the end, so spent longer trying to debug that!

Spoiler

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

[bdjw]

My Attempt

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

[RobertoEstrada]

For this one I did a cross tab for the lookup table and created a new table based on that. Then I did a join of this new table with the data and then just make a formula to get matches.

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

[jagdeep_singh85]

PFA my solution

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