# if A subset of B.

#### sl_apipong

##### New Member
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>

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

#### Gerald Higgins

##### Well-known Member
Hi, welcome to the board.

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

#### Marcelo Branco

##### MrExcel MVP
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

##### New Member
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

##### MrExcel MVP
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.

Replies
7
Views
181
Replies
4
Views
90
Replies
2
Views
75
Replies
16
Views
347
Replies
3
Views
278

1,191,070
Messages
5,984,455
Members
439,889
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back