The spreadsheets of my life
It is not uncommon to face large amounts of data that need to be aggregated across myriad cells in Excel. If you have to =SUMIFS() through big ranges, you might spend too much time waiting for the calculations to finish. Better data structure and focus on efficiency might help you out of this situation. Read More
You can find similar items in Excel based on their underlying properties. Running shoes are used to show how to approach the problem and construct an array formula that gets the job done. Read More
The final touches to the calculator are being put in order for it to be a finished product. Read More
The =CHOOSE() function allows you to define a list and pinpoint a single entry from it to be returned as a result. Since list elements can be both values and references, this solution can be applied in various situations. Read More
The =LOOKUP() function in Excel can return value from a vector that sits against an exact/approximate match in another one. Flexibility can be added in the formula by employing a condition whether some vector elements to be used or not. Read More
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