Forum Discussion

Ronald1969's avatar
Ronald1969
Brass Contributor
Mar 08, 2020
Solved

Remove Dublicate Names from Excel Rows and columns

I am working with a large data of employees and I want to remove duplicate names. I have tried opting option from "Data Tools" -"Remove Duplicate"  checked all columns and said OK, however the respon...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Mar 08, 2020

    Ronald1969 You probably select all the columns at once and then "Remove Duplicates". The help screen states:  "A duplicate value is one where all values in the row are an exact match of all values in another row." Since none of your rows (containing 7 adjacent cells) are exactly the same, no duplicates are found. If you only select the first column and press "Remove Duplicates" the "Apple" at the bottom will be removed.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 08, 2020

Ronald1969 You probably select all the columns at once and then "Remove Duplicates". The help screen states:  "A duplicate value is one where all values in the row are an exact match of all values in another row." Since none of your rows (containing 7 adjacent cells) are exactly the same, no duplicates are found. If you only select the first column and press "Remove Duplicates" the "Apple" at the bottom will be removed.

  • Ronald1969's avatar
    Ronald1969
    Brass Contributor
    Mar 08, 2020
    Thanks for help, I checked, my issue is resolved.

    Thanks once again.

    Ronald Pinto

Resources