Forum Discussion
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 response comes " No Duplicate Values Found".
I have attached a dummy excel sheet, just to give an idea.
Can someone please assist and help me on this issue.
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.
2 Replies
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.
- Thanks for help, I checked, my issue is resolved.
Thanks once again.
Ronald Pinto
