Urgent - How to using formula to compare 2 worksheets
Hi Stefi,
The information are in rows.
"Stefi" wrote:
Can you be more specific on the structure of your sheets: content of columns
and rows!
Stefi
€˛Calculate Date range€¯ ezt Ć*rta:
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.
|