DataFilterAdvanced Filter.

Check "Unique records" and copy to another location.


Gord Dibben MS Excel MVP

On Thu, 28 Jan 2010 14:03:40 -0600, "Doug Mc"
wrote:

Is there some way to delete rows that have duplicate data in one column.
For instance, I have an address list including the whole family.
I would like to delete suceeding rows and leave the first one in that
family.

Thanks,
Doug