The Excel Dynamic Array UNIQUE function returns a list of unique values in a list or range from a source list or range. The values can be text, numbers, dates, times, etc. The UNIQUE function is a major improvement over the legacy complex formula to accomplish the same thing which required Ctrl+Shift+Enter to enter a super complex formula. One huge benefit of this function is that the UNIQUE results are separate from the original data.

Unique-Sort.xlsx