I have a spreadsheet, with a list of days in it. I want to sort them by their order in the week (ie, Monday – Sunday), but Excel being Excel, it seems them as words and sorts them in alphabetical order.
I’ve had a bit of a play and found two functions I never really use, both of which can do this:
This is neat and concise, but just returns the array element number.
A bit longer, but allows you to return arbitrary values, not just the array position.
I’ve been obsessed with automating and scripting things for a while now. I know it’s weird, but I actually enjoy scripting. It’s precise, it’s quick it’s efficient.
I’ve been using vbscript a lot, since you can automate most core components of Windows, you can automate Microsoft Office and also, it’s very easy. It has a syntax that really makes sense to me. There aren’t lots of curly braces, which I’m not a big fan of.
However, today, by chance, I discovered that you can automate much of Photoshop too using Actions. It essentially works by creating a Macro. You click on Window => Actions and then you can record a new action. I wish I’d known this yesterday when I went through and recoloured 26 images. But oh well, you live and learn. So I’ll be less stupid next time, which is all I can hope for.