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
The spreadsheets of my life
Combining drop-down list with named range can produce dynamic solution for more interactive files. With Excel this is easy to make. Read More
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
An overview of the calculator problem that is going to be build in the following posts to demonstrate several key concepts. Read More
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