Differentiating between blank cells

Breiz

New Member
Joined
Oct 5, 2010
Messages
1
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.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,144,567
Messages
5,725,028
Members
422,589
Latest member
JohnnyBravo1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top