VLOOKUP – Thinking outside the box with Schematiq

December 01, 2017 | Kevin Crooks
VLOOKUP is a widely used Excel function. It is commonly found occupying entire columns of a spreadsheet, having been entered in that very first cell and copied down. In addition to the performance penalty that such spreadsheets pay, if the formula has been mis-copied, it can be difficult to see these errors. Schematiq offers a concise and efficient alternative to VLOOKUP, that applies to all rows of your table with a single formula. Sounds too good to be true? Read More

Ready for an Update (columns)?

November 28, 2017 | Kevin Crooks
Imagine a table of data; full of potential insights; but with poorly formatted columns (or at least, not as we would like). How might we tidy these, and prepare the table for analysis? Read More

How to simplify your spreadsheet – Reusing Common Logic

March 20, 2017 | Kevin Crooks
Despite the popularity of languages such as Python and R, Excel still remains the tool that users turn to for data manipulation and data formatting tasks. There are a number of things that users loveabout Excel. In particular it allows you to look through a spreadsheet step-by-step and see how a change propagates through your data in real-time. Read More

Too Many Grades!

April 15, 2016 | Kevin Crooks
How long is a piece of string? Have you ever heard that question? A common answer is “twice as long as from one end to the middle”, but perhaps an overlooked response is “according to which unit of measurement?”.  Read More

Rabbits, Fibonacci & Schematiq

February 03, 2016 | Kevin Crooks
What do breeding rabbits and Schematiq have in common? I hear you ask, or maybe you didn’t. Read More