Hi All,
Can anyone advise me what would be the best way to analyze OPEN-ENDED survey questions thru Excel? I have marketing survey responses from multiple individuals, across multiple sheets. I'm trying to look for some methodology to somehow rank, sort or otherwise prioritize these responses in some manner. Any ideas?
I'm not very good with Excel and I found this link while Google'ing. Trouble is, I can't seem to follow the logic (e.g. I don't follow how the Rand function will help me, in this example). I know -- I'm dumb:
http://survey.cvent.com/blog/cvent-...pen-ended-questions-faster-with-a-quick-trick
Thank you,
NIRAV
Can anyone advise me what would be the best way to analyze OPEN-ENDED survey questions thru Excel? I have marketing survey responses from multiple individuals, across multiple sheets. I'm trying to look for some methodology to somehow rank, sort or otherwise prioritize these responses in some manner. Any ideas?
I'm not very good with Excel and I found this link while Google'ing. Trouble is, I can't seem to follow the logic (e.g. I don't follow how the Rand function will help me, in this example). I know -- I'm dumb:
http://survey.cvent.com/blog/cvent-...pen-ended-questions-faster-with-a-quick-trick
Thank you,
NIRAV
