Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution
Hey, here is my solution. I used slightly different approach. I used the function "FINDSTRING" to find whether "Beep", "Trigger" or "Screen" are present in the string.
I got results in separate fields: Tones, Screen and Trigger.
In order to summarize the buckets I had to so some cleaning in Bucket 1 through Bucket 4.
Let me know any short cut to clean the output in Bucket 1
Hi,
My solution wouldn't be scalable if there would be more positions to search but it works for this exercise.
Solved.