Duplicate Rows

G

Guest

How do I filter rows with duplicate information? I've downloaded a spreadsheet containing about 7,000 rows. Some of those rows contain duplicate data. I would like to keep the first row and delete the duplicate rows.
 
H

Hans

Choose the Advanced Filter and tick the Unique Record only
box. Then copy the data to a new sheet.

regards
Hans
-----Original Message-----
How do I filter rows with duplicate information? I've
Click to expand...
downloaded a spreadsheet containing about 7,000 rows.
Some of those rows contain duplicate data. I would like
to keep the first row and delete the duplicate rows.
 

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

remove duplicate rows from specific data in a column; excel 2007 1
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
complex sort search and replace macro 2
How to Delete duplicate row access 2003 0
Combining duplicate row data 3
Deleting (almost) duplicates in Excel 3
Combining information from rows 3
Keeping duplicate rows 2

Top