View original (French)

Remove duplicates (Excel 2003)

Solved
tanchal29 Posted messages 90 Status Member -  
 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

5 answers

  1. selenetig
     
    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.
    25
    1. Sophie
       
      Great method!
      Thank you very much.
      0
    2. JMichel
       
      Super simple method. It works. 1000 thanks.
      0
    3. Icaribou
       
      thanks for the tip
      0
    4. Nisson
       
      Well explained without frills, a big thank you Nisson.
      0
  2. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    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.
    2
  3. tanchal29 Posted messages 90 Status Member 19
     
    Thank you, Mike.
    I will try tomorrow.
    Have a good evening.
    Chantal
    0
  4. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Re,

    why did you mark the status as resolved when you haven't tested my suggestion yet?
    keep us updated anyway or free up the status

    --
    A+
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    0
  6. tanchal29 Posted messages 90 Status Member 19
     
    Hello everyone,

    Just wanted to say that Mike's formula is awesome!!!!!!!

    A thousand thanks.
    See you soon.
    Chantal
    0