Is there any way to get the multiple results of the check box to be shown in individual excel cells?

  • Profile Image
    Asked on January 24, 2012 at 07:21 AM

    I have a check box in my servey with 20 potential tick box options. When someone ticks more than one option, which is often necessary, the results in the excel report are all shown in one collumn in one cell. Is there any way to get the results to show in one cell for each tick box selected. This will make processing the data a lot easier. 

  • Profile Image
    Answered on January 24, 2012 at 05:23 PM

    No, unfortunately it is not possible to split the response up over multiple cells, but you could use a formula like this on your excel sheet to count the responses of a specific response. 

    e,g if you a looking to count all cells that contain the text/response 'Children' in row B of your spreadsheet, enter the following into a spare cell. 

    =COUNTIF(B:B,"*" & "Children" & "*")

    You can do that for all your possible options and should make processing of your data that little bit easier.

    Does that help?