Forum Discussion
Solved
Delete duplicate rows in excel for each category
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 repetitio...
Under the data tab, select remove duplicates.
At the prompt, select the score column.
Be advised that Excel will keep the first and delete the rest, so do an advanced sort first to order your rows appropriately.
I hope that helps and that I read the question correctly.