Want to get involved? We're always looking for ideas and content for Weekly Challenges.
here is mine
Here is my solution. I chose to use five filters in parallel for each suspect,
In the solution, there does not seem to be a graceful way to deal with separating the company and slogan. For example, one record is "Kerluke West - leverage cross-media users."
The text-to-column used in the solution (using "-'' as the delimiter and splitting into two columns) separates it as the following: "Kerluke" and "West-leverage cross-media users."
As the correct output should be "Kerluke West" and "leverage cross-media users", does anyone know a solution for achieving this?
In the long run, none of the rows that are in the final solution have to worry about this problem, but technically behind the scenes, the text-to-column tool does not work flawlessly.
My twentieth workflow!
Slightly different to the solutions below, I used the formula tool with "if statements" to find the suspects.
My solution 😀