One of Excel’s features which I use frequently is the Advanced Filter – Unique Values.
It’s pretty handy for analysing data and building summary / master tables.
From Excel’s menu: Data > Filter > Advanced Filter…
Copy to another location = selected.
List range: Select the list of values you want to see unique. Include the heading.
Copy to: Select a single cell. You can only copy filtered data to the active sheet.
Unique records only = ticked.
“Copy to” must be the active sheet but “List range” may be another sheet.
Read the comments for more info. Thanks r.venkataraman!