How to Keep the First Duplicate in Excel
Excel's default behavior keeps the first occurrence when removing duplicates.
What "keep first" means
When duplicate values are found, the earliest row in the sheet is kept and later matching rows are removed.
Excel default behavior
Data → Remove Duplicates always keeps the first row of each duplicate set. Sort your data first if needed.
When keep-first is the right choice
Use keep-first for original registration records or first purchase per customer.
Preview before keeping first
The online tool defaults to keep-first and shows which rows will be removed before download.
Tips
- Sort by created date ascending before dedup if first means oldest record
- Backup the sheet—Excel deletion cannot be undone after save
- Use mark-duplicates to compare first vs last before choosing
- Check duplicate group preview for unexpected survivors
Excel Duplicate Removal FAQ
Which row does Excel keep when removing duplicates?
Excel keeps the first row in each duplicate group, meaning the row that appears highest in the current sort order.
How do I keep the oldest record?
Sort by date ascending first, then remove duplicates by the target key. The oldest record will appear first and be kept.
How can I verify keep-first results before deleting?
Use duplicate group preview or mark-duplicates mode to confirm each surviving row matches your business rule before downloading.