Results 1 to 2 of 2

Thread: delete duplicate values

  1. #1

    delete duplicate values



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi

    I have this table. there are some duplicate values in the 1st column, but other does not, I want to delete not just that duplicate value but the whole row where the duplicate email can be found, is this possible?

    email first name last name
    akappel@mysunrise.ch Mélanie Kappel
    ranipia@hotmail.com Gabor Luka
    bernard.reber@img.com Marlis Steiner
    a.klaus@klausadvisors.ch Anita Klaus
    c.nater@finatex.ch Claudia Nater
    bernard.reber@img.com Barbara Studer
    bernard.reber@img.com Michèle Reber
    c.nater@finatex.ch
    Béatrice
    Kühni
    please help me.

    thank you
    Rabeya

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Select the table, then go to Data and select Remove Duplicates. In the popup, uncheck column B and column C, so that only Column A (the column with the duplicate values) remains checked. Then click Ok.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •