In order to use the FILTER, SORT, or UNIQUE functions in Excel, follow the steps below:
- Open Excel and select the desired data range.
- Click the Data tab on the ribbon at the top of the window.
- Choose from the Sort & Filter group:
- Filter to organize data into groups.
- Sort to reorganize data in ascending or descending order.
- Unique to apply distinct filter on the selected data.
- Select the desired options and click OK.
