Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I agree with others' comments on ID 1533. I think the intent was to have the last color be White/Light Grey as the 3rd color, but then colors 1 and 2 are both light grey. Regardless, it works.
All,
Spoiler
That w as a fun, yet quick challenge.
-I used Text-to-column, Data Cleaning, Record ID, Formula (I started with the comment field defaulted to one color, then changed it conditionally to either 2 or 3 colors based on the emptiness of the Color 2 or Color 3 fields.)
-Cheers!
Matt
