[mso] Re: Automatic deletion of duplicate entries in XL sheet ?
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Mon, 13 Jan 2003 14:23:59 -0500
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:
