Fathoming formula

Fathoming formula

Put yourself in the position of a learner … You are following a workbook exercise using Excel. You’ve put the formula in, and entered the data. But something is wrong the number you’ve got is different to the workbook. Option 1: You put your hand up....
Understanding JOINTEXT

Understanding JOINTEXT

Normally we use EQUS to demonstrate numeric computations but here is a nice example with textual data. Inspired by some a tweet from @ddalgleish here is a short video showing JOINTEXT visualised using the EQUS add-in https://youtu.be/g7vaSAlwLkI

LEFT, RIGHT and FIND

Strings and things Think spreadsheets and you normally think numbers. However they are good at many processing tasks including text processing. Here we use a simple example from by Sumit Bansal in trumpexcel.com, extracting the first word from a cell. The article...

Before Modelling …

Developing spreadsheets involves is a balancing act between how much you express in formulae within a single cell and how much you break-up formulae across a number of cells. In many cases a single formula captures much of what needs to be computed, but it is so...