| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Urgent - How to using formula to compare 2 worksheets
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Urgent - How to using formula to compare 2 worksheets
Suppose column A contains Learners' entries in sheet2 (starting in A1),
separated by an empty row, then install this function in a normal module: Function splitlearner(learnerrow) splitlearner = Range("A" & learnerrow & ":A65536").Find(What:="", After:=Range("A" & learnerrow), LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Row End Function Insert this formula in sheet2, cell B1: =IF(AND(NOT(ISBLANK(A1)),LEFT(A1,6)<"course"),IF( splitlearner(ROW())-ROW()-1<6,"Not completed!",""),"") Drag it down until the last row containing data! Regards, Stefi €˛Calculate Date range€¯ ezt Ć*rta: 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. |
| Reply |
| 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 | |||
Hybrid Mode
