How to FIND and REMOVE Duplicates in Excel

About this tutorial:

Video duration: 11:22
Read More:

In this video tutorial, you will learn how to find and remove duplicates in Excel.

This video covers the following examples:
– FIND and HIGHLIGHT duplicates in a single column.
– FIND and HIGHLIGHT duplicates in multiple columns.
– FIND and HIGHLIGHT duplicates rows.
– Remove Duplicate Data points.
– Remove Duplicate Rows.

Find and Highlighting duplicate data points can easily be done using conditional formatting. It has an inbuilt option that allows you to quickly highlight duplicates.

Once you have highlighted…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

7 thoughts on “How to FIND and REMOVE Duplicates in Excel

    Prajjawal Shrivastava

    (January 6, 2020 - 12:23 pm)


    Rajendranath Behera

    (January 6, 2020 - 12:23 pm)

    Very useful tricks, helped me a lot. Thanks for sharing


    (January 6, 2020 - 12:23 pm)

    Q. Need to remove duplicate contacts in a table and keep a single one. I.E I want to keep just “abc ltd” but list contains: abc ltd, ABC Limited, abc-ltd and abc_Ltd with same/similar addresses. Best method please?

    Aparajita Gupta

    (January 6, 2020 - 12:23 pm)


    Shilpi Raj

    (January 6, 2020 - 12:23 pm)

    Very well explained with easy examples..

    Liisa Huusko

    (January 6, 2020 - 12:23 pm)

    YES! Youtube is new google. This did help me in work dramativcally and my customer will enjoy less payment.

    Imad guemmah

    (January 6, 2020 - 12:23 pm)

    very helpful,
    thanks mate

Leave a Reply

Your email address will not be published. Required fields are marked *