If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter and/or remove Names
I have a list of names with matching corresponding companies (6,800 rows).
There are duplicate names and I need to do a mail merge, but don't want the letter to generate for the same party multiple times. How to filter where I can see each name only once. there are too many rows to go through and delete all duplicates. Thanks in advance, |
#2
|
|||
|
|||
Filter and/or remove Names
See Debra Dalgleish's site for instructions of advanced filter for unique
items. http://www.contextures.on.ca/xladvfi....html#FilterUR Scroll down a bit to see how to extract to a new worksheet for your mailmerge. Gord Dibben MS Excel MVP On Fri, 16 Oct 2009 18:19:01 -0700, bronxbabe wrote: I have a list of names with matching corresponding companies (6,800 rows). There are duplicate names and I need to do a mail merge, but don't want the letter to generate for the same party multiple times. How to filter where I can see each name only once. there are too many rows to go through and delete all duplicates. Thanks in advance, |
#3
|
|||
|
|||
Filter and/or remove Names
Use 'Advanced Filter'.
1. Click [Data] tab, [Sort & Filter] Group. 2. Click [Advanced]. 3. Choose [Copy to another location]. 4. Set[List range] to "companies' name scope". 5. Set [Copy to] to "the first cell of result scope". 6. Check [Unique records only]. 7. Click [OK]. "bronxbabe" wrote: I have a list of names with matching corresponding companies (6,800 rows). There are duplicate names and I need to do a mail merge, but don't want the letter to generate for the same party multiple times. How to filter where I can see each name only once. there are too many rows to go through and delete all duplicates. Thanks in advance, |
Thread Tools | |
Display Modes | |
|
|