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:
1When duplicates are removed, the first occurrence of the value in the list is kept, but other identical values are deleted.
