How do I remove duplicated information in 2 columns of Excel?

G

Guest

In Excel 2003 I have two columns, Names & Places, some names have duplicated
places against them and I want to delete these rows completely to give me an
index of which places I can find these names. As I have 300K names and many
have the place duplicated 10 or 20 times, and some places have the names
duplicated, I am eager to find an easy way remembering to keep the
information in their pairs.
 

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

How do I merge duplicated data in rows with different criteria 1
How do I remove all records of duplicated fields? 3
Combine information from rows 6
How do I find meaningful file properties in Excel 2007? 1
How do I combine two spreadsheets and delete the duplicated info 1
Excel Naming columns in excel worksheet 1
Duplicate entry "x" number of times 1
how do i set up to auto detect duplicated numbers in an excel fiel 1

Top