Task 4

Option 2.

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.



+ There are no comments

Add yours