Thursday, June 29, 2023

Let's play with dynamic arrays

 This month's Excel Esports battle wasn't my best performance, but after work (this one was an early-morning competition, starting at 7:30, so I fitted it in before my nine-to-five job) I spent a leisurely hour or so doing the tasks properly, and looking up the most efficient ways to do them. I'm still not one hundred percent certain what a "dynamic array" is, but a lot of people seem to be talking about how great it is that modern Excel can do things with them - and I do now know how to do sumif kind of things on row and column headers, as well as the wonders of 'textbefore' and 'textafter'. These things will come in handy in future competitions - and who knows, maybe in real life too?

But enough of my new competitive obsession. Let's talk about the old one! See, I'm not running an MSO memory competition this year, but I'm already formulating plans for next year's. Let's face it, the MSO format doesn't really fit with the IAM format - the MSO wants short competitions, 4 hours in length at most, and that gives me the opportunity to experiment a bit. Do something different - or dare I say something truly 'memorable'? Stay tuned, and I'll tell you all about it in good time!

Or if you're the person or people who have been reading my old blog entries about the Cambridge/Friendly Memory Championships of years gone by, well, maybe there'll be another one of those next year too! Memory is making a comeback!

No comments: