delete repeating rows

G

Guest

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?
 
P

Peo Sjoblom

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

Guest

I got it! Thanks for your help!

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

--

Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top