Filter formula containing a text

[htittoto]

Hi,

I'm trying to create a formula that uses new formulas SORT, UNIQUE and FILTER to count how many unique equipments  of a particular brand have worked in different construction sites. That main problem is that I dont have a column with exactly the brand name. It is written along with it's model name.

In resume, how may I filter something that contains a group of words? And I have tried using "*"__"*"

Here is the formula wich is not working:

=SORT(UNIQUE(FILTER(CRM[[SITE]:[Sub.Class]];(CRM[SITE]="IACANGA")*(CRM[Sub.Class]="HEAVY")*(CRM[Description]=("*"&"JOHN DEERE"&"*"))));2;1;FALSE)

May somebody help me?

[#2 · Accepted solution]

@htittoto 

Instead of

(CRM[Description]=("*"&"JOHN DEERE"&"*")

use

ISNUMBER(SEARCH("JOHN DEERE",CRM[Description]))

[#3]

@Sergei BaklanThank you for your help, it Works perfectly!

[#4]

@htittoto , you are welcome