From: smaruzzi on
Is there a built-in function providing the same functionalities of Advanced
filter providing the source list and the destination area for the
select-distinct process?

Thanks, Stefano


"Peo Sjoblom" wrote:

> Use data>filter>advanced filter, select unique records only
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "mjlucas49" <mjlucas49(a)discussions.microsoft.com> wrote in message
> news:56E5DD0C-E9D0-4C25-8956-C96F285D320B(a)microsoft.com...
> > How can I compare rows in Excel aand eliminate those rows that have
> duplicate
> > information in them?
>
>
>