Episode 1 of my new podcast, in cooperation with Experts Exchange!
Excel’s unique function will generate a list of all unique values in a range. For example, if you have a column that has “chocolate” listed five times, “vanilla” listed four times, and “mango” listed six times, unique will generate a list of three items: chocolate, vanilla, and mango. The function can also work across multiple fields to consider them as one.