There is a powerful and efficient filtering tool in Excel called Advanced Filter. In addition to filtering values, it has the option of generating a list of unique values. There is one pitfall to avoid when using this in a macro. Continue reading →