combining cells with multiple choices

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:23 AM.