Thanks for the map shoutout! If you want to use complex numbers on MAP cases I would strongly recommend getting rid of the default autocorrect rule that replaces i with I as it's so annoying if you end up hard-coding any complex numbers 🤣
Also IMSUM and IMSUBTRACT or whatever they are called are a bit tempremental on whether inputs are ranges or arrays so if something looks like it should be working and isn't you probably just need to stick a + in front of one of the arguments, or you could just define your own ones that use MAP or put the + in by default
Awesome trick, I've not seen that yet as I've only ever done single arguments to these but I'm sure I'd have been stuck for hours when I do try this had I not seen this!
I think this would fall under the same issue as I have with my SHIFT.ITEMS one in the I would have to assume a delimiter which could then mess me up later, no?
@@Harryjackgross yes but then someone like, well, you (!!), will design a case specifically with the common nonsense delimiters in to trip everyone up 😂
Great
Only at 13:40 and already love VSTACKS and your regex creativity!
Thanks Harry! LOVE the enthusiasm here, some great suggestions to dive into!
best video and upload more
Thanks! I'm trying to work out how to find time to make videos even when it's been busy, but it's been a busy few weeks!
Thanks for the map shoutout! If you want to use complex numbers on MAP cases I would strongly recommend getting rid of the default autocorrect rule that replaces i with I as it's so annoying if you end up hard-coding any complex numbers 🤣
Yes yes yes! How do I turn that off?! Can I also turn off accidently making the copyright symbol every time I'm lazy with naming? (c)
@@E_Pats Yes you can! File > Settings and then I think the section is called 'Proofing' or something and you can delete the rules individually there
Also IMSUM and IMSUBTRACT or whatever they are called are a bit tempremental on whether inputs are ranges or arrays so if something looks like it should be working and isn't you probably just need to stick a + in front of one of the arguments, or you could just define your own ones that use MAP or put the + in by default
Awesome trick, I've not seen that yet as I've only ever done single arguments to these but I'm sure I'd have been stuck for hours when I do try this had I not seen this!
For the Cartesian product you could make it do the triple with textjoin/textsplit too!
I think this would fall under the same issue as I have with my SHIFT.ITEMS one in the I would have to assume a delimiter which could then mess me up later, no?
@@E_Pats You can pick the wackiest symbol delimiters of all time to avoid this - there is one called the Angzarr which has **unknown meaning**
@@Harryjackgross yes but then someone like, well, you (!!), will design a case specifically with the common nonsense delimiters in to trip everyone up 😂
Also, in a work setting, I don't trust anyone to not use wacky delimiters...
Would I do that 😇
Can tell you are a mathematician haha
@@HadynWiseman because of my pretty hair, right?
@@E_PatsMathematicians have the best hair…