Forum Discussion
original and duplicate removal in excel
I 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.
I 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.
- Thanks for quick reply.
I mentioned "original and duplicates have to be removed" .
Anyhow your second answer is useful to me. original and duplicates showing in some color. sorting by coloring and then easily able to remove.
