You could try Advanced Filter (from the data tab of the ribbon) filtering either in place or creating a unique list elsewhere. Check "Unique entries only" and nothing in the Criteria Range.
Does that help?