Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
This was a fun one.
I first parsed out the AM/PM (using Text to Columns) and the Hour (Using Regex), I then used Text to Columns to split the data to a row per each employee.
Next, I determined those workers who had worked out of the hours worked by our pesky saboteur, and joined back to the main stream using the join to remove these employees.
This left me with a reduced list of suspects. I then grouped by suspect and counted the numbers of victims, filtering down to only those that could have been involved in all 7 incidents.
This left me with the following list of suspects:
Once I interrogated these suspects I got the following:
Then it was a simple matter of using Regex to parse out the name of the person, and using a formula tool to remove the space, reverse the string and make it upper case.
M.
