Remove duplicates (Excel 2003)
Solved
tanchal29
Posted messages
90
Status
Membre
-
Nisson -
Nisson -
Good evening everyone,
I need to carry out a mail merge. However, I realize that I have a lot of duplicates.
Am I forced to delete them line by line, or is there a formula that allows eliminating a line that appears twice?
Thank you for your help.
Attached is the type of files.
https://www.cjoint.com/?BJkvmX5s1nG
I will be using Excel 2003 at work.
Have a good evening.
Chantal
I need to carry out a mail merge. However, I realize that I have a lot of duplicates.
Am I forced to delete them line by line, or is there a formula that allows eliminating a line that appears twice?
Thank you for your help.
Attached is the type of files.
https://www.cjoint.com/?BJkvmX5s1nG
I will be using Excel 2003 at work.
Have a good evening.
Chantal
5 réponses
It's simpler!
In the "data" tab, select filter and then advanced filter.
In the "range" box, indicate the range with duplicates.
In the "copy to" box, specify a destination for the range without duplicates.
Check "unique records only"
and click OK.
You will then have a list without duplicates, saving you from the tedious step of removing the colored cells.
In the "data" tab, select filter and then advanced filter.
In the "range" box, indicate the range with duplicates.
In the "copy to" box, specify a destination for the range without duplicates.
Check "unique records only"
and click OK.
You will then have a list without duplicates, saving you from the tedious step of removing the colored cells.
Hello,
Several options, completely automatic with a VBA code if you have some knowledge
or with conditional formatting that highlights duplicates and manually you select the highlighted rows and delete them
for Excel 2003
start by selecting the range in column A containing the values to test, then Format/Conditional Formatting/ the formula to paste is
=COUNTIF(OFFSET($A$1,0,0,ROW()-1),OFFSET($A$1,ROW()-1,0))>0
format and choose a fill color
with this formula only the duplicate cells in the range will be highlighted, and you can delete them
--
A+
Mike-31
A period of failure is the perfect time to sow the seeds of knowledge.
Several options, completely automatic with a VBA code if you have some knowledge
or with conditional formatting that highlights duplicates and manually you select the highlighted rows and delete them
for Excel 2003
start by selecting the range in column A containing the values to test, then Format/Conditional Formatting/ the formula to paste is
=COUNTIF(OFFSET($A$1,0,0,ROW()-1),OFFSET($A$1,ROW()-1,0))>0
format and choose a fill color
with this formula only the duplicate cells in the range will be highlighted, and you can delete them
--
A+
Mike-31
A period of failure is the perfect time to sow the seeds of knowledge.
Thank you very much.