delete repeating rows

I have a spreadsheet that has names and vacation dates in each column. Some
of the rows are repeating and I have to manually delete the repeating rows.
Is there a formula to delete the duplicate rows?

You can use data>filter>advanced filter and select unique records only and
copy to another location

--

Regards,

Peo Sjoblom


"aledger" <aledger@discussions.microsoft.com> wrote in message
news:398053DF-EAC0-4E07-9165-916501FF20F2@microsoft.com...
> I have a spreadsheet that has names and vacation dates in each column.
Some
> of the rows are repeating and I have to manually delete the repeating
rows.
> Is there a formula to delete the duplicate rows?

I got it! Thanks for your help!

"Peo Sjoblom" wrote:

> You can use data>filter>advanced filter and select unique records only and
> copy to another location
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "aledger" <aledger@discussions.microsoft.com> wrote in message
> news:398053DF-EAC0-4E07-9165-916501FF20F2@microsoft.com...
> > I have a spreadsheet that has names and vacation dates in each column.
> Some
> > of the rows are repeating and I have to manually delete the repeating
> rows.
> > Is there a formula to delete the duplicate rows?
>
>
>