Excel 2002 mailing list in spreadsheet

G

Guest

I have a mailing list in a spreadsheet. Last name, first name and address
are in the first 3 columns, extra info is in the following columns - There
are multiple rows for each household. How can I delete duplicate rows
(names) so that I have a spreadsheet with one row for each household.
 
G

Gord Dibben

lilly

I assume the multiple households all have the same address.

Use Data>Filter>Advanced Filter on that selected column.

Check "unique records only" and "copy to new location".

For more on this, including copying the unique list to another sheet, see
Debra Dalgleish's site for more on Advanced filtering.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben Excel MVP
 

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

Combining info for mailing labels 1
how do I remove repetitive cells in an excel database? 5
How do I merge duplicated data in rows with different criteria 1
How do you delete duplicate addresses, but keep duplicate names? 1
Mail Merge 1
Show only rows with duplicate values in a column? 4
merging spreadsheets 2
Best solution for removing duplicate content with conditions? 2

Top