How can I use the FILTER, SORT, or UNIQUE function in Excel?

< 1 min read

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.