if A subset of B.

[sl_apipong]

Dear MrExcel,
I stuck with this formula when i have "/"(or) in the cell.
Any suggestion how can i get the result from this?

Best Regards,
Apipong L.

								B
								a
								b1/b2/b3
								c
								d
								e1/e2
								f
A	1	a	b1	c	d	e1	f	TRUE
	2	a	b2	c	d	e1	f	TRUE
	3	a	b3	c	d	e1	f	TRUE
	4	a	b1	c	d	e2	f	TRUE
	5	a	b2	c	d	e2	f	TRUE
	6	a	b3	c	d	e2	f	TRUE
	6	a	b4	c	d	e2	f	FALSE
	8	a	b3	c	d	e2	g	FALSE

<tbody>
</tbody>

 

[Gerald Higgins]

Hi, welcome to the board.

Your request is extremely vague, what are you trying to do exactly ?

 

[Marcelo Branco]

Welcome to Mr Excel

Maybe...

	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​	Set B​		Set A​						Formula​
2​	a​		a​	b1​	c​	d​	e1​	f​	TRUE​
3​	b1/b2/b3​		a​	b2​	c​	d​	e1​	f​	TRUE​
4​	c​		a​	b3​	c​	d​	e1​	f​	TRUE​
5​	d​		a​	b1​	c​	d​	e2​	f​	TRUE​
6​	e1/e2​		a​	b2​	c​	d​	e2​	f​	TRUE​
7​	f​		a​	b3​	c​	d​	e2​	f​	TRUE​
8​			a​	b4​	c​	d​	e2​	f​	FALSE​
9​			a​	b3​	c​	d​	e2​	g​	FALSE​

Formula in I2 copied down
=SUMPRODUCT(--ISNUMBER(MATCH("*/"&$C2:$H2&"/*","/"&$A$2:$A$7&"/",0)))=COUNTA($C2:$H2)

Hope this helps

M.

 

[sl_apipong]

Thanks both to reply,
Sorry that my description is not clear.
Branco get my point and this gorgeousformala for me.

may i put little bit complexier

Best Regards,
Apipong L.

					CI No.	49241	49241	49241
					Variant3	LFUEL210/LFUEL315/LFUEL405/LFUEL610,TNK-SING	LFUEL210/LFUEL315,TNK-DUAL/TNK-SING	FAA20,ENG-VE11,FUEFC1LW FAA20,ENG-D8,UEAS/EAS-SCR
Unit Number	J9X	FZX	KDX	DPX	A9B
800749	RFUEL405	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800750	RFUEL405	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800751	RFUEL405	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800752	RFUEL405	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800753	RFUEL315	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800754	RFUEL315	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800755	RFUEL315	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800756	RFUEL315	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800757	RFUEL405	FAA20	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800758	RFUEL405	FAA20	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800759	RFUEL405	FAA20	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
800760	RFUEL405	FAA20	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
14366	RFUEL405	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
14367	RFUEL405	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
14368	RFUEL405	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
14369	RFUEL405	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
14370	RFUEL405	FAA10	TNK-SING	ENG-VE11	UFUEFC	Y/N?	Y/N?	Y/N?
14371	RFUEL315	FAA10	TNK-SING	ENG-D8	FUEFC1SW	Y/N?	Y/N?	Y/N?
14372	RFUEL315	FAA10	TNK-SING	ENG-D8	FUEFC1SW	Y/N?	Y/N?	Y/N?
14373	RFUEL315	FAA10	TNK-SING	ENG-D8	FUEFC1SW	Y/N?	Y/N?	Y/N?
14374	RFUEL315	FAA10	TNK-SING	ENG-D8	FUEFC1SW	Y/N?	Y/N?	Y/N?
14375	RFUEL315	FAA10	TNK-SING	ENG-D8	FUEFC1SW	Y/N?	Y/N?	Y/N?

<tbody>
</tbody><colgroup><col><col span="5"><col><col><col></colgroup>

 

[Marcelo Branco]

Don't understand what you are trying to do.
Which subsets do you want to compare? What are the expected/desired results?
Could you provide a more detailed explanation?

M.