Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2002 mailing list in spreadsheet
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. |
#2
|
|||
|
|||
lilly
I assume the multiple households all have the same address. Use DataFilterAdvanced 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 On Mon, 29 Aug 2005 13:52:19 -0700, lillysmom wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
How do I search a mailing list spreadsheet to remove entries alre. | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |