Delete duplicate rows in excel for each category

Question

I have 2 columns name and Score. I would like to delete duplicate rows for each category(Name).For instance- i would like to see one of the Scores(2) to be removed for rahul as there is a repetition( 1,4 record) while, the&nbsp; score 2 that is mapped to shyam( last record) should not be deleted.Name &nbsp; &nbsp;ScoreRahul &nbsp; &nbsp; 2Ravi &nbsp; &nbsp; &nbsp; 4Shyam &nbsp; 5Rahul &nbsp; &nbsp;2Ravi &nbsp; &nbsp; &nbsp; 6Rahul &nbsp; &nbsp; 4shyam &nbsp;&nbsp;2Output after removing duplicatesName &nbsp; &nbsp;ScoreRahul &nbsp; &nbsp; 2Ravi &nbsp; &nbsp; &nbsp; 4Shyam &nbsp; 5&nbsp;Ravi &nbsp; &nbsp; &nbsp; 6Rahul &nbsp; &nbsp; 4shyam &nbsp;&nbsp;2&nbsp;

detlef_lewin · Accepted Answer

Hi&nbsp;Use the Remove Duplicates feature.&nbsp;Leave both columns checked and press OK.&nbsp;See also this video from Debra Dalgliesh.

Forum Discussion

Delete duplicate rows in excel for each category

2 Replies

Resources