(Msg. 1) Posted: Fri Oct 16, 2009 6:19 pm
Post subject: Filter and/or remove Names Archived from groups: microsoft>public>excel>setup (more info?)
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.
(Msg. 2) Posted: Sat Oct 17, 2009 7:49 am
Post subject: Re: Filter and/or remove Names [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
See Debra Dalgleish's site for instructions of advanced filter for unique
items.
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
<bronxbabe DeleteThis @discussions.microsoft.com> 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,
(Msg. 3) Posted: Mon Oct 19, 2009 1:38 am
Post subject: RE: Filter and/or remove Names [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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,
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office