Challenge #11: Identify Logical Groups

[Jonathan-Sherman]

Challenge 11 is done!

Spoiler

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

[Niklas]

No complaints 😉

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

[FRANCK_ROUQUETTE]

Interesting exercice - I did both solutions (with and without macro) as you suggested. Thank you

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

[Vidya26]

My Solution!!

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

[Tom_Luthi]

solution attached.

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

[AndrewS]

Went with Append Fields, but after looking at solution2 I think the text to columns with Find Replace approach is the way to go. 

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

[wdavis]

Initially didn't split all text by individual word so was only getting one count per row. Text to columns helped me fix this!

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

[mmenth]

Spoiler

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

[ConradW]

11 done

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

[ddiesel]

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.