Splitting Multiple Choice

[dofrancis]

Dear Team,
I reach out to you to request your support !

As per my Excel sheet attached, could you help me with a formula that can allow me to splitting multiple choice in multiple colomns.

I can get result only for one colomn but i would like to get results for 2 or 3 colomns.

Thank you for your support.

 

[DanteAmor]

Hi and welcome

Try:

varios 28sep2024.xlsm
	A	B	C	D	E	F
1		1_Source	2_Source		Com_Info_centre	Gong_gong
2		Rel Radio	Radio Com_Info_centre		1	0
3		Gong_gong Mobile	Health Gong_gong V		0	2
Hoja3

Cell Formulas
Range	Formula
E2:F3	E2	=ISNUMBER(SEARCH(E$1,$B2))+ISNUMBER(SEARCH(E$1,$C2))

 

[dofrancis]

Hi and welcome

Try:

varios 28sep2024.xlsm
	A	B	C	D	E	F
1		1_Source	2_Source		Com_Info_centre	Gong_gong
2		Rel Radio	Radio Com_Info_centre		1	0
3		Gong_gong Mobile	Health Gong_gong V		0	2
Hoja3

Cell Formulas
Range	Formula
E2:F3	E2	=ISNUMBER(SEARCH(E$1,$B2))+ISNUMBER(SEARCH(E$1,$C2))

Dear DanteAmor;
Thank you for your replay but please could you help me
How can i use this formula if i have TWO sheets like below:

 

[DanteAmor]

Do the rows on sheet2 correspond to the same row on sheet1?
Does the data on both sheets start in cell A1?

Note XL2BB:

For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.​

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in​

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.​

If the above is correct, try:

varios 28sep2024.xlsm
	A	B	C	D
1			Com_Info_centre	Gong_gong
2	r1	d1r1	1	0
3	r1	d2r1	0	2
Sheet2

Cell Formulas
Range	Formula
C2:D3	C2	=ISNUMBER(SEARCH(C$1,Sheet1!$C2))+ISNUMBER(SEARCH(C$1,Sheet1!$D2))

 

[dofrancis]

Do the rows on sheet2 correspond to the same row on sheet1? YES
Does the data on both sheets start in cell A1? NO

 

[dofrancis]

Please could you send me an email to dofrancis3@yhoo.fr so that i can share the xlxs fil with you

 

[DanteAmor]

The follow-up to the thread must be with a post in the same thread.
Put your information here in the thread using the XL2BB tool as I mentioned in post #4

There you can see the formula. We assume that if you don't put the information correctly as it is on your sheets, then you will adapt the formula.

 

[dofrancis]

Dear @DanteAmor
As per your question, note that:
- The rows on sheet2 correspond to the same row on sheet1
- The data on both sheets aren't start in cell A1
Please could you send me an email to dofrancis3@yhoo.fr so that i can share the xlxs fil with you

 

[DanteAmor]

Please could you send me an email to dofrancis3@yhoo.fr so that i can share the xlxs fil with you

That is not possible due to the Forum Rules

As I told you, you should be more explicit with your information or try to adapt the formula. In my example from post #4 the formula works.

Use the XL2BB tool.

If you want help, you must help us help you.

 

[dofrancis]

That is not possible due to the Forum Rules

As I told you, you should be more explicit with your information or try to adapt the formula. In my example from post #4 the formula works.

Use the XL2BB tool.

If you want help, you must help us help you.

Yes but i can't add i go a message below: