My Excel Esports Lambda Collection

[@shanksingh7613]

Great

[@Harryjackgross]

Only at 13:40 and already love VSTACKS and your regex creativity!

[@E_Pats]

Thanks Harry! LOVE the enthusiasm here, some great suggestions to dive into!

[@shanksingh7613]

best video and upload more

[@E_Pats]

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!

[@Harryjackgross]

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 🤣

[@E_Pats]

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)

[@Harryjackgross]

@@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

[@Harryjackgross]

For the Cartesian product you could make it do the triple with textjoin/textsplit too!

[@E_Pats]

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]

@@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**

[@E_Pats]

@@Harryjackgross yes but then someone like, well, you (!!), will design a case specifically with the common nonsense delimiters in to trip everyone up 😂

[@E_Pats]

Also, in a work setting, I don't trust anyone to not use wacky delimiters...

[@Harryjackgross]

Would I do that 😇

[@Harryjackgross]

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

[@E_Pats]

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!

[@HadynWiseman]

Can tell you are a mathematician haha

[@E_Pats]

@@HadynWiseman because of my pretty hair, right?