[mso] Automatically deleting double excel records
- From: "4office" <4office@xxxxxxxxxxxxx>
- To: "Office (E-mail)" <mso@xxxxxxxxxxxxx>
- Date: Tue, 17 Dec 2002 23:13:58 -0500
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:
