[mso] Re: Automatically deleting double excel records
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 17 Dec 2002 23:36:36 -0500
Hi April....I got this question from you about four times...twice here and
twice privately...LOL
I replied to you privately...but I'll copy it here so the rest of the group
can see what I said and add any other comments since I'm really busy here
and don't want to leave you hanging:
__________________________
Don't copy it to a new sheet....copy it to the same sheet, in a different
location....don't copy it in place cuz it leaves the extra ones there,
that's why you still have 10,273
And I can't imagine why you thought it came from Vic...since my signature is
on it (not to mention the fact that Vic doesn't know anything about
Excel...LOL)
Take care.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of 4office
Sent: Tuesday, December 17, 2002 11:14 PM
To: Office (E-mail)
Cc: vaf@xxxxxxxxxx; 'Linda Johnson (E-mail)'
Subject: [mso] Automatically deleting double excel records
I saved this comment from an old email in case I ever needed it ... and now
I do, but I can't seem to get it to work right. I don't know if this came
from Vic or Linda, that is why I cc you both... I have an excel list of name
and addresses... 10,273 to be
exact... when I tried this it tells me that it filtered it down to 9919, but
it is showing all 10,273 names.... When I try to get it to copy to a new
sheet it wont do it... can anybody please help me???? April
-----Original Message-----
From: Vic [mailto:vaf@xxxxxxxxxx]
Sent: Friday, April 05, 2002 2:48 PM
To: MicrosoftOffice@xxxxxxxxxxxxxxx
Subject: Re: [MSO] Automatically deleting double excel records
OK....I'm feeling generous here.....to delete duplicates, highlight all the
data, the go to the Data menu and choose Filter>Advanced Filter.....choose
whether you want to filter the list in place or put your new list in a new
location....then put a check in the box that says "Unique Records
Only"....this will get rid of all the *exact* dups.
Linda
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
