No matter what you use Excel for, you will always come across the need to generate a list of unique values from a range. Or in other words the need to get rid of duplicates in a list.

The following trick is a quick and easy way of getting a list of unique values using the “Advanced Filter” function.

More >