Challenge #289: Prep a Shoe List

[Amanda_Vinduska]

Done! For the comment I was able to vastly reduce the formulas needed to get the desired output by using a RegEx_countmatches function. Take a look!

[aatalai]

C289

[jsifontes]

Here's my solution to this challenge!

Spoiler

[WalkerChance]

Solved. Solution can be simplified based on ask

[Nams]

Enjoyed this one - but did wonder about the fact that there are 5 duplicate rows with the same ID.  Should these be identified and removed (using Unique tool)? 

[Raees09]

My solution

[Hannah_Bartholomew]

Spoiler

Spoiler: 

[Lied]

submission

[ftamer]

My solution: 

if IsNull([colors2]) && IsNull([colors3]) then "1 color available" elseif IsNull([colors3]) then "2 colors availabe" else "3 colors available" endif

[Zongkai]

Getting ready for Core exam.