How to Quickly Remove Duplicate in Excel
How to Quickly Remove Duplicate in Excel @BrainUpp
Remove duplicate values
Select the range of cells that has duplicate values you want to remove. Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.
Click Data - Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates. ...
Click OK.
Filter for unique values or remove duplicate
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.
How To Remove All Duplicates But Keep Only One In Excel?
In Excel, the Remove Duplicate feature can help you remove all but keep one duplicate value.
1. Select the data list you need, and click Data - Remove Duplicates.
2. Then in Remove Duplicates dialog, check the column name that you want to remove duplicates from, and if your data has header, check My data has headers option, too.
3. Click OK. And a dialog pops out to tell you how many duplicates have been removed, just close it. And now all duplicates have been remove but keep only one in the list
Remove All Duplicates But Keep Only One With VBA
If you are interested in VBA, here I also can introduce a VBA code to solve this task.
1. Press Alt +F11 keys simultaneously to open Microsoft Visual Basic for Applications window.
2. Click Insert - Module, and paste below VBA to the new Module window.
VBA: Remove all duplicates but keep one.
Sub RemoveAllDeplicateButOne()
Dim LR As Long: LR = Range("A" & Rows.Count).End(xlUp).Row
ActiveSheet.Range("A1:A" & LR).RemoveDuplicates Columns:=1, Header:=Name
End Sub
3. Press F5 key or click Run to execute the VBA, and the duplicates in list in column A have been removed but keep one.
Tip: In the above VBA, A indicates the column A, and A1: A indicates the list range, you can change them as you need.
Remove All Duplicates But Keep Only One With Kutools For Excel
There is a powerful utility in Kutools for Excel named Select Duplicate & Unique Cells can quickly select or highlight all duplicates except first one, and then you can remove them.
After free installing Kutools for Excel, please do as below:
1. Select the data range and click Kutools - Select - Select Duplicate & Unique Cells.
2. In the displayed dialog, check Duplicates (Except 1st one) option, and click Ok.
3. Then a dialog pops out to remind you the number of selected cells. And just click OK to close it.
4. And all the duplicates but first one are selected, press Delete key to clear them
Tip: You also can remove all duplicates but keep one with Select Duplicate & Unique Cells like this:
Select all the unique values including the first duplicates, and then copy them by pressing Ctrl + C and paste to another location by Ctrl + V.
Related Search-
how to remove duplicates in excel
remove duplicates in excel 2020
how to delete duplicates in excel
removing duplicates in excel
remove duplicates in google sheets
remove duplicates in excel formula
remove duplicates in excel shortcut
highlight duplicates in excel
how to identify duplicates in excel
excel remove duplicate rows based on one column
how to remove duplicates in excel 365
how to remove duplicate names in excel
remove duplicates excel mac
Смотрите видео How to Quickly Remove Duplicate in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Brain Up 30 Июль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,085 раз и оно понравилось 29 людям.