Excel 2002 mailing list in spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top