Filter

[Glenn]

I have a table that has various fields on information such as name, address,
phone number.

I would like to generate a mailing list so that one household per phone
number gets the mailing (John Doe & Jane Doe have separate records, but
share the same phone number - I want for their household to only get one
copy of the mailing).

Is there a way to do this, and if so, how?

Thanks,
Glenn

 

[Bradley Dawson]

The best way is to use Word and use the Excel file as the database. Use the
Word help files on Mail Merge to get details.

 

[Debra Dalgleish]

You can add a column to the table, and use a formula to number the
occurrence of each phone number. For example, if the phone numbers start
in cell F2, enter the following formula in cell G2:

=COUNTIF($F$2:F2,F2)

Copy the formula down to the last row of data.
Then choose Data>Filter>AutoFilter, and filter column F for records that
contain a 1.

Or, use an Advanced Filter to extract the records to a new location.

 

[Karen S]

-----Original Message-----
I have a table that has various fields on information such as name, address,
phone number.

I would like to generate a mailing list so that one household per phone
number gets the mailing (John Doe & Jane Doe have separate records, but
share the same phone number - I want for their household to only get one
copy of the mailing).

Is there a way to do this, and if so, how?

Thanks,
Glenn


.
This is not a complete answer, but might give you some

ideas.

You could create another column, and create an if-then
formula where, if cell [phone number] equals any other
cell [phone number], a value shows up in this new
column's cell.

You then could do a two-part sorting. Sort by this new
column, allowing all the rows that have no value in this
new "duplicate indicator" column to list first. You
generate your mailing labels from that section of the
list.

You then do a second sort, selecting only those flagged
phone-number duplicates. Then- well, I'm not sure how you
would sort them- but depending on how many names you
have, maybe a somewhat manual process would be manageable
at that point. Hope this triggers something for you.