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?