Sorting in Excel - Unique records in Excel

For Sorting

 > First Select the columns

> Click on Data Menu

> Click on Sort

> Select the Column (Sort By)

> Click on OK

==============================

For Unique Records

> First Select the column

> Click on Data

> Click on Advanced

> Check on Unique Records 

> Click on OK

ref:- https://support.microsoft.com/en-us/office/filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2