Grouping TRUE/FALSE answers into a single cell.

Hi Benjamin_Draper 

thanks for the file. First of all, you need to link every checkbox to a cell. Right-click on the ceckbox and select "Format control..."

Then link it to the cell right below the checkbox:

The cell will get the value TRUE or FALSE based on wether the checkbox is checked or unchecked.

(You can make the TRUE/FALSE values invisible later by changing the font color to white or with a user defined number format)

Last thing is to concatenate all values in the column B, D and E that have a TRUE statement in the cell right to them.

Unfortunately, this is going to be a very long formula in Excel 2016. I just did it in the attached file for column B, so you can get the idea:

=IF(C3=TRUE,B3,"")&IF(C4=TRUE,", "&B4,"")&IF(C5=TRUE,", "&B5,"")&IF(C6=TRUE,", "&B6,"")&IF(C9=TRUE,", "&B9,"")&IF(C10=TRUE,", "&B10,"")&IF(C11=TRUE,", "&B11,"")&IF(C12=TRUE,", "&B12,"")&IF(C13=TRUE,", "&B13,"")&IF(C14=TRUE,", "&B14,"")&IF(C15=TRUE,", "&B15,"")&IF(C16=TRUE,", "&B16,"")&IF(C17=TRUE,", "&B17,"")&IF(C18=TRUE,", "&B18,"")&IF(C19=TRUE,", "&B19,"")&IF(C20=TRUE,", "&B20,"")&IF(C21=TRUE,", "&B21,"")&IF(C22=TRUE,", "&B22,"")&IF(C23=TRUE,", "&B23,"")&IF(C24=TRUE,", "&B24,"")&IF(C25=TRUE,", "&B25,"")&IF(C26=TRUE,", "&B26,"")&IF(C29=TRUE,", "&B29,"")&IF(C30=TRUE,", "&B30,"")&IF(C31=TRUE,", "&B31,"")

There might be more sophisticated solutions, but this was the only one I can think of at the moment.

Just for information: With Excel in Microsoft 365, you get the same result with just this simple formula:

=TEXTJOIN(", ",TRUE,FILTER(B3:B31,C3:C31=TRUE))

I have attached your sample file where I have prepared it for columns B/C.

Hope this helps.