deleting duplicate rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that contains over 1700 rows of data. The problem is that some rows are duplicated or tripled. This doesn't seem to have a pattern. The column that shows if a row is duplicated is column H.

How can I make it understand that if h3=h2, I want it to delete the whole of row 3? I'm not sure if I need a formula with an "if" statement or a macro. I've written simple ones of each before, but this escapes me. Please help!

Thanks in advance..
Jennifer
 
You must log in or register to reply here.

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

Similar Threads

Duplicate Rows 2
Delete duplicate and original row 3
Eliminate Duplicate Row 1
looking for duplicates 3
Duplicates Deletion ? 2
How do I merge duplicated data in rows with different criteria 1
Duplicate data 2
How to Delete duplicate row access 2003 0

Back
Top