Blog Archive: May 2025

"You only know what you know how to google" - Martin Childs, 2016 This post was supposed to be about how create a custom Excel VBA function, the origination of the idea was despite my lifelong career of tinkering with excel I'd never come across or had the requirement to have a function cycle through the cell you input as a range to perform a   more »

There are some things that aren't easy to do in SQL as you'd like. I don't know why it has to make the seemingly simple things to complete in Excel so annoyingly tricky. Dynamic pivots is one of those things that is overcomplicated, sure there's plenty of tutorials on the t'internet , but what they all seem to lack is instructions of how to write   more »

Whilst we were out in Tanzania on Safari something wasn't quite adding up, every night at the hotels there was several Lamb dishes to be found on the menu. The thing was vexing me was that despite being in the country for nearly a week and spending at least eight hours a day driving through various types of countryside I'd yet to lay eyes on   more »

As much as I love Excel there are some circumstances where it just doesn't cut it - more than a millions rows and computer says no; some rediculouse vlookup and you could be there for hours. So step in SQL, it can do those aforementioned tasks in a matter of seconds. There are a couple of occasions though where SQL is not king, one of these is   more »

One of the common themes of the computer industry is to try to install a load of bloat on your computer under the guise of making it easier for you, well when I first got my Dell E310dw and had a flick through the setup guide to head off any such shinangans I noticed they had some sort of 'universal' installer. Trying not to fall for that I   more »