Match cell in a range

[audax48]

Hi experts, I need some help please, Column E is populated with 10 numbers (E1-E10)
In B1, C1 and D1 simple digits.
I'd like to get in Column F a new list with the numbers that have only one of the digits given in B1 C1 D1.Ex


B1=2, C1=4 D1=5 Column E= 021, 035, 187, 292, 425, 328, 654, 768, 945 y 437 then Column F= 021, 035, 328, 437
Thank you a lot

 

[wideboydixon]

Using a helper column in G:

Book1
	B	C	D	E	F	G
1	2	4	5	021	021	1
2				035	035	1
3				187	328	0
4				292	437	2
5				425		3
6				328		1
7				654		2
8				768		0
9				945		2
10				437		1
Sheet1

Cell Formulas
Range	Formula
F1	{=IFERROR(INDEX($E$1:$E$10,SMALL(IF($G$1:$G$10=1,ROW($E$1:$E$10)-ROW($E$1)+1),ROWS($F$1:$F1))),"")}
G1	{=SUM(LEN(TEXT($E1,"000"))-LEN(SUBSTITUTE(TEXT($E1,"000"),$B$1:$D$1,"")))}
Press CTRL+SHIFT+ENTER to enter array formulas.

WBD

 

[audax48]

100% Thanks a Lot