Another horrible Excel formula

There should be an annual prize for the worst one.

Q&A: Ctrl+z undo after using macros / Excel Calculations no longer work / Selecting cells

Hi, I would like to know why my undo shortcut (ctrl + z) is not working after doing the ctrl + shift + A. Is it because it's working as a macro so undo shortcut wouldn't work afterwards? Is there any solution to that? Thank you! Weile Hey Weile.

Q&A: What to do if Control+Shift+0 is not working to unhide columns

We like to be able to hide unused columns at the end of the model timeline. If we need to change the timeline we want to be able to easily unhide columns again. The Excel keystroke to unhide columns is Ctrl+Shift+0. Many users find that this does not

Guidance for beta readers

Beta readers are helping to make this book better. If you contribute you'll get named in the book and will receive a free copy when it's published.

Adding more time granularity with partial period factors

[Placeholder page - content to follow]

The 1.4m formula

My friend Gerard shared this one. It measures 1.4m if you stretch it out. Brilliant. Keep them coming.   =IF(AND( $N97<>1,$O97<>1),$F97*$I97 * IF( AND( HeavyVehInd=2, X$4>=RoadStartYr), (1-$L97),(1-$K97))*(1-INDEX( X$5:X$7, MATCH($Q97,

How to sense check the units in your model

Like checking for duplicate row labels, checking the units in your model is not something you'll have to do very often. It can help you pick up errors and inconsistencies, however. Quite often, inconsistencies can creep into the units in our model. For example, we might be working

How to check and correct label capitalisation

It doesn't matter how you choose to capitalise words in labels; what matters is having a consistent approach and sticking to it.

How to check for duplicate row labels

Inconsistent labelling impedes model clarity. In a big model, it can be easy to lose track of what we have called things and for duplicates to creep in.

How to check and reset the used range in Excel

Excess "used range" in Excel can cause the file size to be larger than necessary. This guide will show you how to check and correct this.