Please do as follows.īefore applying Kutools for Excel, please download and install it firstly.ġ. Or you can select all duplicates and delete them as you need. The Select Duplicate & Unique Cells utility of Kutools for Excel help you easily select all unique cells at once in a list, and then you can extract these unique cells into a new column with copying and pasting. See screenshot:įilter out duplicates and keep unique values with Kutools for Excel
Then the duplicates are filtered out and only the unique values are displayed in list. In the Advanced Filter dialog box, select Filter the list, in-place option in the Action section, check the Unique records only box, and then click the OK button. Select the list you need to filter out duplicates, then click Data > Advanced. You can apply the Advanced Filter feature to filter out duplicates in a list and only keep the unique values. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
