Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA nice challenge! I solved it with an iterative macro and only basic tools, eager to look now at your more sophisticated solutions.
I'm working towards my advanced certification and trying to get practice with iteration macros. I have a programming background but can't quite seem to get the hang of how they exit.
I got this one to work, but I think it's kind of clunky. If anyone can explain a better way to iterate/exit I would appreciate it! I updated this to use the CrewTest expect equals tool instead of Test tool. I realized I had configured it wrong, so went for easier option.
Workflow:
This one took longer than it should because I misread the instructions and built a beautiful macro to solve an entirely different problem. Fortunately I was able to adapt it to the real problem -- a great example of how workflows are much easier to refactor than code or spreadsheet programs.
this was some good practice for iterative Macros. Don't use it often so I keep forgetting details of the setup and configuration, but always happy for a refresher.
Iterative Macro:
My solution
Wow I really struggled with this one. I did figure out how to do it manually, but I wanted to get the macro to work as I need some practice with macros. My macro didn't stop iterating when it got to the "true" condition - does anyone have tips on that?