Prev: PERCENTILE for a range
Next: Count unique names in a list
From: DogmaDot on 18 Mar 2010 12:42
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?
From: Gord Dibben on 18 Mar 2010 18:18
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
<DogmaDot(a)discussions.microsoft.com> 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?

 | 
Pages: 1
Prev: PERCENTILE for a range
Next: Count unique names in a list