Bound4Glory
New Member
- Joined
- Jun 21, 2020
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
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)
I'm not sure what I'm doing wrong, been trying various formulas but keep getting errors.
Thank you,
Shaun
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