Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution 🙂
I opted for the data cleanse tool instead of the filter to get rid of the null values. I realized afterward that the reason my solution was not working was that I had not inserted a sort prior to concatenating and thereby was unable to count the unique combinations.
I tried to find a method using the formula and unique tool but had not figured it out and scrapped it. Will come back to this challenge again to find another way.
Hint...Spin...and re-spin