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

On Thu, 18 Mar 2010 09:42:04 -0700, DogmaDot
wrote:

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?