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
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.
Extracting unique items from 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