Task 4


Cleaning Data Sources

At times markbook versions are collated and you can end up with many duplicates

Conditional formatting can be used to remove duplicates.

 

Highlight the data set.

Select data tab

Select remove duplicates

Select All

Click ok

+ There are no comments

Add yours