Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
My First Weekly Challenge. I tried using the MultiField Formula with Regex but, being completely new to Regex it was taking a lot of time.
So I moved on to a different approach. Here I got stuck at how to loop the Text to Column tool for several columns and spent quite some time trying to create a macro.
Finally, i just randomly tried the Summarize tool and got it working. This was fun and I will try to contribute regularly.
Great way to learn new stuff !!
-Aditya S
Here is my solution.
My first ever attempt at one of these - I am a very basic user but I enjoyed this one
Would greatly appreciate any feedback on this from anyone
My version:
My version:
Here's my solution. I'm sure it can be done in fewer tools but I quite enjoyed being in the "flow" of solving this one and ended up dragging in tools like a crazy person.