combining cells with multiple choices

		Microsoft Office Forums > Microsoft Excel > Excel
combining cells with multiple choices

FAQ

Thread Tools

Display Modes

01-13-2017, 01:12 PM

H28Sailor

Windows 7 32bit combining cells with multiple choices

Office 2007

Advanced Beginner

Join Date: Mar 2013

Posts: 55

combining cells with multiple choices

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining several cells data into one single cell	H28Sailor	Excel	6	01-09-2017 06:00 AM
Combining 2 tables into 1 and use Table2's column widths (hoping for workaround dealing merged cells	CodingGuruInTraining	Word VBA	24	10-07-2015 07:48 PM
Drop down lisr with multiple choices	Richard121	Excel	1	02-17-2015 08:30 AM
Combining multiple bulleted lists	TigerDroppings	Word	2	03-09-2013 07:08 AM
Combining Text from Table Cells	robmorleyuk	Word	1	11-01-2011 07:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 PM.