Hi I have been trying in vain to solve this problem so I am hoping that someone will be able to help me...?
I need to calculate survival rate of a questionnaire:
I have a data sheet with answers to a questionnaire (numbers). Some people have abandoned the questionnaire and others have skipped questions. I need to be able to differentiate between blanks caused by skipping the question and blanks caused by the abandon of the questionnaire.
If I can either mark the last answer or mark the unanswered questions in between the answered questions I would be very happy!! I don't mind creating another matrix or using VBA!!
I can't go through it by hand it would take me a month!
Thanks ever-so-much.
I need to calculate survival rate of a questionnaire:
I have a data sheet with answers to a questionnaire (numbers). Some people have abandoned the questionnaire and others have skipped questions. I need to be able to differentiate between blanks caused by skipping the question and blanks caused by the abandon of the questionnaire.
If I can either mark the last answer or mark the unanswered questions in between the answered questions I would be very happy!! I don't mind creating another matrix or using VBA!!
I can't go through it by hand it would take me a month!
Thanks ever-so-much.