Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi, a good challenge. Used the filter tool to get the relevant data. Followed by the summarize. Used formula tool and a sequence of select, sort and sample to get the calculated items togather. Finally used the join multiple.
2 solutions
Method 1 - includes hard coding month/year (part 1). Part 2 - brute force
Method 2 - uses first and last instead of hard coding month/year (part 1). Part 2 - more elegant solution.
Prefer method 2.