Combining the =INDEX() and =MATCH() functions is a way to save on time and possibly some document performance. In this post the simplest use of the functions is used to extract data from a two-dimensional table. Read More
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