[mso] Re: Automatic deletion of duplicate entries in XL sheet ?
- From: David Good - ANSYS Europe <david.good@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Thu, 16 Jan 2003 05:15:41 -0500
>>Is this clearer? Yes, the range has to be on the same sheet.
Linda, your method is perfect, but I thought I'd chime in with a nice work
around for a way to copy filters to different sheets - it's dead simple too
- all you have to do is START on the destination sheet, then specify the
RANGE on the different sheet. Oddly Excel can cope with this - never
understood why it only works this way around.
HTH,
Dave.
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: 15 January 2003 21:48
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Automatic deletion of duplicate entries in XL sheet ?
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
*************************************************************
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:
