In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists.
Eric Hoffer
The greatest value of a picture is when it forces us to notice what we never expected to see.
John W Tukey, Exploratory Data Analysis

Four Thousand Weeks (2020)

An alternative view of being productive and striving to do the most you can, in the time you have.

Being efficient and effective is messy and a one size fits all rule based system usually won’t last or work.

Has some good ideas on what to focus on and what not to focus on.


Jean-Georges Vongerichten showed me the value in taking away, taking things off of a plate. … The more you put on the plate, the easier it is to hide. The more you take away, there’s nowhere to hide—it has to be good.

Chef Wylie Dufresne

A Conversation with Wylie Dufresne

Stop Excel Control being Clicked

Textbox hack

In a protected worksheet users can still click on checkbox and option button controls. A warning message will pop up if the control’s linked cells are locked. There is a technique you can use to stop users clicking on these controls. This involves a macro that you can run just before you protect the sheet.

Drop Down Selection update


It has taken a decade or so but Excel finally has an in-cell drop down that you can type a letter and reduce the entries listed – see screen shot below.

Fixing the UNIQUE Function

The UNIQUE function in Excel has a problem when it comes to handling blank cells. Blank cells are treated as zero and if you have a blank cell and a zero in a range then UNIQUE will return two zeros. Also, if a cell has a function that returns a blank cell, then that is treated differently than a blank cell. Let’s create a custom function to fix UNIQUE’s blank cell blind spot.