Buscar
How to remove duplicates in Excel | Xyclos
Actualizado: 21 dic 2022
First, find duplicates values in a column, using Conditional formatting
Click in the column you want to inspect
Home/Conditional formatting/Highlight cell rules/Duplicate values...
Then activate Filters
Click on the column's filter
Select Filter by color
Select Filter by cell color
Now you can delete duplicate rows with duplicated values
There is another option:
Clic kon any cell of a list
Go to Data tab
In the group Data Tools, clic on Remove duplicates
In the window Remove duplicates, click on Unselect all button
Select the column where you think there are duplicates
Click Ok button A window message is displayed with the results
Σχόλια