Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThank you for your helpful suggestion!
Actually, I didn't think of the Summarize tool in this context at all, but I agree that I could use it to replace the "Unique" tool making my first solution less confusing. Or did you refer to something else?
Attempt at challenge#9.
Oh sorry, I meant it in reference to your comment that you wished there was a min/max tool. Summarize with the Min/Max calculations basically is a min/max tool.
Hey beautiful people. Here is a SUPER convoluted way to solve this. I'm posting my first draft of it so I'm sure by the time you read this, I will have devoured the solution and have committed to memory a method to tackle this type of problem more efficiently. In any case...enjoy this crazy version.