Hi



I am using the following formula for combing cells where there is only one choice
=IF('1'!AY2=1, "Mon",IF('1'!AZ2=1, "Tues",IF('1'!BA2=1, "Wed",IF('1'!BB2=1, "Thurs",IF('1'!BC2=1, "Fri",IF('1'!BD2=1,"Sat","Sun"))))))

What do I need to change if it is a multiple choice question with any number of choices chosen

i.e. output something like

Mon + Tues + Sun

Bob M

If you use Excel 2016, and with

1 Mon
1 Tue
1 Wed
1 Thurs
1 Fri
1 Sat
1 Sun

in A1:B7 the following array formula:

=MID(CONCAT(IF(ISNUMBER(A1:A7),B1:B7&" + ","")),1,LEN(CONCAT(IF(ISNUMBER(A1:A7),B1:B7&" + ","")))-2)

will return

Mon + Tue + Wed + Thurs + Fri + Sat + Sun

Please remember that an array formula must be completed by holding down Ctrl and Shift before pressing Enter.