Excel Remove Duplicates - Which Occurrence Is Kept?
In Excel, When Removing Duplicate Rows While Ignoring Certain Columns (Data → Data Tools → Remove Duplicates → Unselect Ignored Columns), Some of the Values in...
In Excel, when removing duplicate rows while ignoring certain columns (Data → Data Tools → Remove Duplicates → unselect ignored columns), some of the values in the ignored columns disappear entirely. Which ones are kept? The first occurrence of each duplicate?
1 Answer
The first occurrence is kept. The page Filter for unique values or remove duplicate values says:
When duplicates are removed, the first occurrence of the value in the list is kept, but other identical values are deleted.
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
