How to filter for unique values or remove duplicate values in MS-Excel

Have a large list of data with certain fields containing duplicate records (e.g. "order number" or "date") and you want to only see the unique records? Use this: Filter for unique values or remove duplicate values - Excel - Microsoft Office Online