Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEACompleted
Reading the instructions was really helpful in getting the right answer here. Easy to get something close to the right answer only to realize you forgot a step in the middle or at the beginning.
I learned
1. Sometimes I can present the answer simply, yet more tools would make it look the way they want
2. Sorting is usually important before the multi-row formula tool
3. In the Summarize tool you can pass unrelated data through using the "group by" functionality (but only if you can be sure that that will not change the summarization).
3. Being dynamic can be a challenge. It is really only useful if you need the workflow to function with new/different inputs. That said, it can make the programming more interesting.
My solution: