Category Archives: Excel

Microsoft Excel is a spreadsheet developed by Microsoft for WindowsmacOSAndroid and iOS.

Filter for unique values or remove duplicate values from Excel OR CSV

In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.