ExcelBanter - delete duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - delete duplicates (https://www.excelbanter.com/excel-discussion-misc-queries/259253-delete-duplicates.html)

DogmaDot

delete duplicates

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?

Gord Dibben

delete duplicates

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?

All times are GMT +1. The time now is 04:06 AM.