Sep 08 2020 10:55 AM
i would like to remove if any row is having duplicate entry , those original and duplicate should be removed. can someone help me.
Sep 08 2020 11:30 AM
SolutionI can see two interpretations to your request,1) Remove duplicates leaving only unique values or 2) If any group of rows repeat, remove them all.
The first.
1) Select all rows
2) Use Excel's menu Data > Remove Duplicates.
The second.
1) Select all rows
2) Use Excel's menu Home > Conditional Formatting > Highlight Cell Rules > Duplicate Values
3) Right click on a highlighted cell and select Filter > Filter by Cell's Color
4) Select filtered cells
5) Right click and select Delete Row and click OK to delete entire sheet row
Let me know if either of these is on target.
Sep 09 2020 07:52 AM
Sep 08 2020 11:30 AM
SolutionI can see two interpretations to your request,1) Remove duplicates leaving only unique values or 2) If any group of rows repeat, remove them all.
The first.
1) Select all rows
2) Use Excel's menu Data > Remove Duplicates.
The second.
1) Select all rows
2) Use Excel's menu Home > Conditional Formatting > Highlight Cell Rules > Duplicate Values
3) Right click on a highlighted cell and select Filter > Filter by Cell's Color
4) Select filtered cells
5) Right click and select Delete Row and click OK to delete entire sheet row
Let me know if either of these is on target.