[mso] Re: Automatic deletion of duplicate entries in XL sheet ?
- From: Anne <chesteranne@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 15 Jan 2003 22:34:19 +0100
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
Linda F. Johnson a mail=E9 :
>If the rows are EXACT duplicates, you can remove them by using an Advanced
>Filter.
>
>Highlight all the data, go to the Data Menu and choose Filter>Advanced
>Filter. Select to move it to a new location and put a check in Unique
>values only. This will remove EXACT duplicates.
>
>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: Monday, January 13, 2003 2:12 PM
>To: mso@xxxxxxxxxxxxx
>Subject: [mso] Automatic deletion of duplicate entries in XL sheet ?
>
>
>
>Good evening,
>
>I would like to know if it is possible to eliminate automatically duplicate
>entries in an XL database (let's say I have X lines and Y columns and I
>would like to eliminate all lines that have exactly identical data in all
>columns).
>
>?
>
>Thanks in advance for any advice.
>
>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:
