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
Category: Advanced Techniques
This category offers detailed tutorials on how to perform specific task by employing approaches beyond the basics. Pictures and additional files are to be expected alongside the comments.
Excel =LOOKUP() with conditions
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
Dynamic length named range for drop-down list
Combining drop-down list with named range can produce dynamic solution for more interactive files. With Excel this is easy to make. Read More
Extracting the unique items from a list of entries
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