MID Formula
This post follows on from our post dated 2 June 2017 and deals with extracting data from the middle of a string of information....
DOUBLE CLICKING TO A FORMULA
Double Clicking in a cell to take you directly to the source of data of the formula is possibly one of the most useful tricks available...
Many (thousands of) Rows
We often analyse files containing many hundreds or thousands of rows, with multiple columns of data. With this amount of data it can be...
Spreadsheet v Database
A question that we are being asked more and more is “When should I use a database rather than a spreadsheet?” Excel and Access are, in...
Hash # Errors and IFERROR
One of my bugbears is a report that includes a # error, such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! My eye is drawn...
Excel SUBTOTAL Function
The SUBTOTAL function can be used with a variety of calculations, such as SUM, AVERAGE, COUNT and many more. We will look at the most...
