SOLVED

original and duplicate removal in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1645395%22%20slang%3D%22en-US%22%3Eoriginal%20and%20duplicate%20removal%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1645395%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20would%20like%20to%20remove%20if%20any%20row%20is%20having%20duplicate%20entry%20%2C%20those%20original%20and%20duplicate%20should%20be%20removed.%20can%20someone%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1645395%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1645466%22%20slang%3D%22en-US%22%3ERE%3A%20original%20and%20duplicate%20removal%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1645466%22%20slang%3D%22en-US%22%3EI%20can%20see%20two%20interpretations%20to%20your%20request%2C%201)%20Remove%20duplicates%20leaving%20only%20unique%20values%20or%202)%20If%20any%20group%20of%20rows%20repeat%2C%20remove%20them%20all.%20The%20first.%201)%20Select%20all%20rows%202)%20Use%20Excel's%20menu%20Data%20%26gt%3B%20Remove%20Duplicates.%20The%20second.%201)%20Select%20all%20rows%202)%20Use%20Excel's%20menu%20Home%20%26gt%3B%20Conditional%20Formatting%20%26gt%3B%20Highlight%20Cell%20Rules%20%26gt%3B%20Duplicate%20Values%203)%20Right%20click%20on%20a%20highlighted%20cell%20and%20select%20Filter%20%26gt%3B%20Filter%20by%20Cell's%20Color%204)%20Select%20filtered%20cells%205)%20Right%20click%20and%20select%20Delete%20Row%20and%20click%20OK%20to%20delete%20entire%20sheet%20row%20Let%20me%20know%20if%20either%20of%20these%20is%20on%20target.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1645485%22%20slang%3D%22en-US%22%3ERe%3A%20original%20and%20duplicate%20removal%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1645485%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F778499%22%20target%3D%22_blank%22%3E%40rajeshmanepalli987%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20see%20two%20interpretations%20to%20your%20request%2C%3CSPAN%3E1)%20Remove%20duplicates%20leaving%20only%20unique%20values%20or%202)%20If%20any%20group%20of%20rows%20repeat%2C%20remove%20them%20all.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20first.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E1)%20Select%20all%20rows%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E2)%20Use%20Excel's%20menu%20Data%20%26gt%3B%20Remove%20Duplicates.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20second.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E1)%20Select%20all%20rows%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E2)%20Use%20Excel's%20menu%20Home%20%26gt%3B%20Conditional%20Formatting%20%26gt%3B%20Highlight%20Cell%20Rules%20%26gt%3B%20Duplicate%20Values%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E3)%20Right%20click%20on%20a%20highlighted%20cell%20and%20select%20Filter%20%26gt%3B%20Filter%20by%20Cell's%20Color%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E4)%20Select%20filtered%20cells%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E5)%20Right%20click%20and%20select%20Delete%20Row%20and%20click%20OK%20to%20delete%20entire%20sheet%20row%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ELet%20me%20know%20if%20either%20of%20these%20is%20on%20target.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

i would like to remove if any row is having duplicate entry , those original and duplicate should be removed. can someone help me.

2 Replies
Best Response confirmed by rajeshmanepalli987 (Occasional Contributor)
Solution

@rajeshmanepalli987 

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.