delete duplicates

D

DogmaDot

I love this feature in excel, but it would be nice to be able to know which
ones are deleted. Some of my records are more complete than others and I
would like to ensure that the more complete record is retained. Is there a
way to do this?
 
G

Gord Dibben

My limited testing seems to show that the first of each duplicate is
retained.

Make sure the "more complete" records are at top of sheet.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Weigh tasks 0
How to create a bubble chart with more than 2 variables. 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Duplicates Deletion ? 2
Have 4 email addresses Want to auto forward all in one of them 0
remove duplicates but retain one not delete both 4
Changing defauls in 2019 0

Top