Want to get involved? We're always looking for ideas and content for Weekly Challenges.
using Summarize i have done
The multi-row formula tool is a fave of mine. In the case, the count distinct on the summarize tool is more efficient.
here is my solution
Fun challenge 🙂
attaching my solution