Customer filter

[Hussein982]

Hi All: I have a file that contains thousands of rows and trying to only filter for certain operating units (such as Operating unit A, B and C)

Can I use the custom filter function and build a formula such as:  Operating unit "A" AND "B" AND "C"  to select specific operating units. 

Currently its not working for me. Any help in appreciated. 

Operating unit	Supplier Number	Supplier name
A	1	1A
B	2	1B
C	3	1C
D	4	1D

[Luke_C]

Hi @Hussein982 

You could use a custom filter like this:

[Operating unit ] in ('A','B','C')

[echuong1 · Accepted solution]

Another method (that may be easier to maintain if you need to add/remove operating units) is to use a reference table with the operating units needed, and a join.

[Hussein982]

@Luke_C  thank you for your prompt response.