Jump to content
Jen

Analyzing codes for separate Excel spreadsheet columns

Recommended Posts

I have imported an Excel spreadsheet that has an ID column and several additional columns, each of which represents responses to a different open-ended survey question. Rows represent respondents.  I have been able to code each cell separately (e.g., Respondent 1's Q1, Respondent 1's Q2, Respondent 2's Q1, Respondent 2's Q2).  The coding stripes do not differentiate among columns, however; they show all codes assigned to any of a single respondent's columns.  So, for example, how do I filter so that I can analyze only the codes for respondents' answers to Q1 and Q2 and exclude (for the moment) codes from the Q3 and Q4 columns? 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×