combine two records into one record in an Excel database

[Guest]

I have a mailing list in Excel, where each person is a seperate record. I have a code for each seperate household (MAIL_ID). I would like to produce a new file/worksheet which just has each household record, for mailing.

For example, I have:
Last First MailId Street1 Street2 City Zip
Smith John 1 123 Main St Anytown 00000
Smith Mary 1 123 Main St Anytown 00000

Since I have the same mail code for both, I only want one new row so I only send one piece.

Any ideas?

 

[Don Guillett]

why not a for/each sub on the mailid instead

I have a mailing list in Excel, where each person is a seperate record. I

have a code for each seperate household (MAIL_ID). I would like to produce
a new file/worksheet which just has each household record, for mailing.

 

[Guest]

Don't know what that is....is that a macro or VBA? I don't know how to do those

----- Kurt P wrote: -----

I have a mailing list in Excel, where each person is a seperate record. I have a code for each seperate household (MAIL_ID). I would like to produce a new file/worksheet which just has each household record, for mailing.

For example, I have:
Last First MailId Street1 Street2 City Zip
Smith John 1 123 Main St Anytown 00000
Smith Mary 1 123 Main St Anytown 00000

Since I have the same mail code for both, I only want one new row so I only send one piece.

Any ideas?

 

[Dave Peterson]

Chip Pearson has a bunch of techniques for dealing with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

 

[Guest]

Thanks. The cpearson.com website was a great help. After the function to code duplicates, all that was required as a few if statements and some sorting to get what I wanted. Problem solved, without any VBA!