I loved this case! It was the first time I ever used the SCAN function. P.S.: I was surprised you didn’t use MOD in the setup at the start! And I think your formula that wouldn’t work for the whole sentence at once was because you had an AND in there, so it was collapsing one of the array calculations down to a single value.
I am starting to discover the beauty of SCAN only recently :) MOD for some reason is just not so intuitive for me! You are right on the array calculation, it's very powerful but also dangerous...
Hi Fernando, thanks! You can purchase the cases on FMWC website, they contain the right answers. For the solutions you can check my channel - I plan to cover all the cases soon - but also Diarmuid's channel is quite rich in terms of solutions!
I loved this case! It was the first time I ever used the SCAN function.
P.S.: I was surprised you didn’t use MOD in the setup at the start! And I think your formula that wouldn’t work for the whole sentence at once was because you had an AND in there, so it was collapsing one of the array calculations down to a single value.
I am starting to discover the beauty of SCAN only recently :)
MOD for some reason is just not so intuitive for me!
You are right on the array calculation, it's very powerful but also dangerous...
Nice work! Where can I find this kind of exercises to practice? Do they have the solution on order to check your work?
Hi Fernando, thanks! You can purchase the cases on FMWC website, they contain the right answers. For the solutions you can check my channel - I plan to cover all the cases soon - but also Diarmuid's channel is quite rich in terms of solutions!