V
vlookupabyss
I am busy working with an Excel report that lists multiple records per
user/learner name. So for example a learner can have 5 e-learning activities
records against their name with 8 different attempts so in effect 8 attempt
records against their name for 5 activities. There is a completion status
field that will show either Completed or Registered. However if the learner
completes an activity and then launches it again two records will display in
the report – one completed and one registered. Now here comes the rub! I need
only the completion status record IF they have completed it and only the
registered record if they have NOT completed it. So in the case of multiple
records where learners have completed activities and then opened them again
and there are both completed and registered records I only need the completed
record but in the case of learner who have only opened but not completed
activities I only need the registered record!
The fields are : name , id , org, activity name (this is the e-learning
activity), registration date and start date (which are the same as learners
in effect register themselves when they launch a course) completion date
(this is the field that will appear blank if the learner has not completed an
activity) status (either completed or registered – in the case of registered
completion date will be blank but start date and registration date will have
a date)
user/learner name. So for example a learner can have 5 e-learning activities
records against their name with 8 different attempts so in effect 8 attempt
records against their name for 5 activities. There is a completion status
field that will show either Completed or Registered. However if the learner
completes an activity and then launches it again two records will display in
the report – one completed and one registered. Now here comes the rub! I need
only the completion status record IF they have completed it and only the
registered record if they have NOT completed it. So in the case of multiple
records where learners have completed activities and then opened them again
and there are both completed and registered records I only need the completed
record but in the case of learner who have only opened but not completed
activities I only need the registered record!
The fields are : name , id , org, activity name (this is the e-learning
activity), registration date and start date (which are the same as learners
in effect register themselves when they launch a course) completion date
(this is the field that will appear blank if the learner has not completed an
activity) status (either completed or registered – in the case of registered
completion date will be blank but start date and registration date will have
a date)