Hi all,

I have 2 worksheets to compare as follows:-

sheet 1 with 6 courses to be completed by learners (these are a compulsory
courses)

course 1
course 2
course 3
course 4
course 5
course 6

In worksheet 2
I have hundred learners who have completed some course from the above

Learner A has comepleted
course 1
course 3
course 5

Learner B has completed
Course 2
course 3
course 5
coursse 6

Learner C has completed all course
course 1
Course 2
course 3
course 4
course 5
course 6


How to set a formula to know who dose not completed the courses for a
hundred over learners


Thank you in advanced.