| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Urgent - How to using formula to compare 2 worksheets
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| use central formula on many worksheets, central affect allsheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
