Excel Remove Duplicates - which occurrence is kept?

Question

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?

root · 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.

Excel Remove Duplicates - which occurrence is kept?

One Answer

Add your own answers!

Ask a Question