filtering

[thewillemzelluf]

Best,

I am working on a employee file. However, I would like to filter on every employee with 'flex' in the name. For example, I want a filter with / without flex. Any idea how this should be done? Below is an example of the data.

Greetings, Willem

[Somasundaram]

In Name filter just search *flex*

[brunobertels]

Hi 

Somethink like this 

in a filter pane 

=if(wildmatch(NAME,'*Flex*'),'FLEX','OTHER')