[mso] Re: Automatic deletion of duplicate entries in XL sheet ?
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 15 Jan 2003 16:48:02 -0500
Ok. Are you sure you are entering the parameters correctly in the Advanced
Filter box?
Here's an example:
Lets say the data is in cells A1 to F10 and you want to remove the
duplicates and create a new list starting in A12....
Highlight A1:F10
Go to Data>Filter>Advanced Filter
Select Copy to another location
Click your mouse inside the box that says "Copy To", then simply click
inside cell A12 and the copy to box will be filled in automatically and
should say something like Sheet1$A$12
Then put a check in the box that says unique records only and click OK.
Is this clearer? Yes, the range has to be on the same sheet.
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 Anne
Sent: Wednesday, January 15, 2003 4:34 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Automatic deletion of duplicate entries in XL sheet ?
Thank you, Linda.
I'm still stuck though... maybe I'm stupid:-)
I tried that and it says "you can only copy filtered data into the active=20
sheet". If I try to NOT copy to a different location, it says nothing but=20
does not remove the duplicate rows. And when I try to copy to a different=20
location in the same -active- sheet, it says "incorrect data transfer".=20
(These are my translation of the messages 'cause my XL is in french,=20
version Office 97 at work and Office 2K here at home).
I think I should enter some filtering criterias but what can I use to just=
=20
say "everything" ?
Suggestions anyone ?
Tia
Anne
*************************************************************
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:
