I love to see another happy convert! : ) I know you say you don't feel comfortable with it, but it looks like you've got 90% of the ideas in your head already - I think you'll find it starts to come together a lot more naturally with a few more reps. P.S.: you're accidentally still using your helper column in the final formula - you'd need to replace the B2# in the REDUCE with SpaceCount
It was great to follow along your journey Giles! I think I start doing those challenges as well to improve my Excel skills and learn about different ways to solve those problems!
Yes, do it! I worked out last night it’ll take me about 10 years to complete all existing challenges if I do one a week, so I may have to tackle these a bit faster 😬
@@ExcelOnTheRoad thanks for the encouragement! Oh woah! That many challenges are there, already out! Is it recommended to start from the very first one and work your way 1 by one?
HI Giles. Nice try... I thought you were going to include the headers using Vstack with array constants as column names. At work, I solve all the pieces of information one by one and then glue them together using LET and Lambdas thinking that I am Dim Early. Haha! (In my dreams!)
@@ExcelOnTheRoad the -- is just converting text or true false in this case to numbers it's like (-1)*(-1). You can even replace it with 1* if that is easier to remember.