• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Assemble survey data

J

jonnieRC

New Member
Hi there, i have a dataset which consists of 1=yes 0=no type information and I am looking to start to interpret it. I thought I could do a countif but cannot seem to work it.

Has anyone any tips, i have attached a sample of the information. Would really appreciate some help on this :)

Thanks in advance,
JRC
 

Attachments

  • Dataset for query.xlsx
    477 KB · Views: 10
Insert a new column to the left of Column A. In row 11264 place a 1 and in row 11265 place a zero. In B11264 type =COUNTIF(B1:B11262,$A$11264) and in B11265 type =COUNTIF(B2:B11262,$A$11265) and then copy both cells accross.
 
Hi:

I am not sure what kind of analysis you are looking for. I have transformed your raw data using power query and pulled a pivot to summarise the data(sheet2)

Thanks
 

Attachments

  • Dataset for query.xlsx
    572.5 KB · Views: 7
You must log in or register to reply here.
Back
Top