TransWikia.com

Excel Remove Duplicates - which occurrence is kept?

Super User Asked on December 25, 2021

In Excel, when removing duplicate rows while ignoring certain columns (DataData ToolsRemove Duplicates → unselect ignored columns), some of the values in the ignored columns disappear entirely. Which ones are kept? The first occurrence of each duplicate?

One 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.

Answered by root on December 25, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP