Filter function multiple criteria same column (partial match)

[Bound4Glory]

Hi,
I need to filter for two partial matches from the same column.

In the example below, I need to filter for "*99P07H*" and "*08865*" under Column A (Barcode)

Barcode	Trailer	Route	Trip
99P180--13131KNXK-02402801820	99T000000824466	002B4	5F6EF
99P07H--13131KNX2-02412824726	99T000000824466	002B4	5F6EF
99M200643350011668363	99V3H3V452C7JT320535	070M6	7119
99M200643350011654997	99V3H3V452C7JT320535	070M6	7119
99M200643350011508865	99V3H3V452C7JT320535	070M6	7119
99M200643350011597579	99V3H3V452C7JT320535	070M6	7119

I'm not sure what I'm doing wrong, been trying various formulas but keep getting errors.

=FILTER(A:D, ISNUMBER(SEARCH({"*99P07H*","*08865*"}, A:A)))

Thank you,
Shaun

 

[kevin9999]

Until a more elegant solution comes along, this might work for you:

Book1
	A	B	C	D	E	F	G	H	I
1	Barcode	Trailer	Route	Trip		Barcode	Trailer	Route	Trip
2	99P180--13131KNXK-02402801820	99T000000824466	002B4	5F6EF		99P07H--13131KNX2-02412824726	99T000000824466	002B4	5F6EF
3	99P07H--13131KNX2-02412824726	99T000000824466	002B4	5F6EF		99M200643350011508865	99V3H3V452C7JT320535	070M6	7119
4	99M200643350011668363	99V3H3V452C7JT320535	070M6	7119
5	99M200643350011654997	99V3H3V452C7JT320535	070M6	7119
6	99M200643350011508865	99V3H3V452C7JT320535	070M6	7119
7	99M200643350011597579	99V3H3V452C7JT320535	070M6	7119
8
Sheet1

Cell Formulas
Range	Formula
F1:I1	F1	=A1:D1
F2:I3	F2	=FILTER(A:D,(LEFT(A:A,6)="99P07H")+(RIGHT(A:A,5)="08865"))
Dynamic array formulas.