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 datafilteradvanced filter and select unique records only and
copy to another location

--

Regards,

Peo Sjoblom


"aledger" wrote in message
...
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 datafilteradvanced filter and select unique records only and
copy to another location

--

Regards,

Peo Sjoblom


"aledger" wrote in message
...
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?