Thread: [Solved] combining cells with multiple choices
View Single Post
 
Old 01-13-2017, 11:02 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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.
Reply With Quote