Blog

The Punctuation Guide

About a month ago I posted about The Data Visualisation Catalogue. If you have data to visualise, hit up this website, tell it what you’re trying to show, and it will suggest some appropriate chart/graph types.

Today I’ve come across another single-purpose website that I think is great, and it’s audience is intended to be a little more general than people who want to visualise their datasets.

It’s The Punctuation Guide!

When I discovered it I fully expected not to learn anything new, merely to receive confirmation that my use of punctuation was already top-notch.

I was, of course, incorrect.

Check out the site to see what you’ve been doing incorrectly your whole life! One word of caution: the guide is intended primarily for writers of American English. There’s a page that explains the main differences between that and British English. Here in Canada you should probably be doing something in-between the two, but if you’re looking for specifics I’m the wrong person to ask.

Blog

Extract a List of Values Filtered by Criteria with Sub-Arrays in Excel

If you’re not careful then array functions in Excel can quite easily melt your brain and cause it to leak out through your various face-holes, so I’m finding this step-by-step guide especially useful this morning.

Extract a List of Values Filtered by Criteria with Sub-Arrays in Excel