Challenge #11: Identify Logical Groups

[archietao]

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

[archietao]

Hi all,

Can anyone help me with the batch macro solution? I'm still new and was trying to replicate the Batch Macro Solution hoping i can learn how to use that Macro. However, my workflow doesn't work for some reason. it would be much appreciated if anyone can point out what's wrong with my workflow/macro.  

Thanks,

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

[Verakso]

At first the challenges can look really simple, until you take a path and it won't work.

So did I with this, I struggled to use the Find Replace Tool, since I thought it would be obvious to use here.

Well it wasn't at least not to me, so I ended up doing something similar to others, but it bothers me a bit, that I seem to solve most of the puzzles using the Formula Tool.

Spoiler

I did notice after my own effort, that the provided solution #2 is actually using the Find Replace Tool, but with apparently a slightly different approach than I was. Perhaps I am trying to cut to many corners...

//Thomas 

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

[jbranaum]

Here is my solution, non macro approach.

Thanks!

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

[Karam]

My solution 🙂

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

[yajing_wang]

My easy lazy way

Spoiler

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

[NikolajFrosig]

Spoiler

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

[SamDesk]

Spoiler

Sam 🙂

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

[AlexCox]

My solution

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

[JoeS]

Append and contains filter for me 🙂

Spoiler

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