Combining drop-down list with named range can produce dynamic solution for more interactive files. With Excel this is easy to make. Read More
Dynamic length named range for drop-down list
Posted on
Extracting the unique items from a list of entries
Posted on
Formulas compatible with Excel 2007 and later are used to extract unique values from a list of entries. It is also demonstrated how extra conditions can be added for precise control if the items should be shortlisted or not. Read More
(Overview) The gas money splitting tool
Posted on
An overview of the calculator problem that is going to be build in the following posts to demonstrate several key concepts. Read More
3 principles for great spreadsheets
Posted on
In order to make spreadsheets better for everyone involved with them, there are many rules to follow. 3 of them are Being aware of the end user; Putting proper checks; and Avoiding hard inputs.
In this post I explain why. Read More