Here is an example of cleaning data source.
I have a data set of students and their marks in different subjects and there are duplicates. I will use conditional formatting to remove duplicates.
Select the data set, go to home, conditional formatting,
Highlight cell rules, highlight duplicate values then manually delete duplicates.
You must log in to post a comment.