Feb 07 2020 10:32 AM
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?
Feb 07 2020 12:49 PM
SolutionInstead of
(CRM[Description]=("*"&"JOHN DEERE"&"*")
use
ISNUMBER(SEARCH("JOHN DEERE",CRM[Description]))
Feb 13 2020 01:55 AM
@Sergei BaklanThank you for your help, it Works perfectly!
Feb 07 2020 12:49 PM
SolutionInstead of
(CRM[Description]=("*"&"JOHN DEERE"&"*")
use
ISNUMBER(SEARCH("JOHN DEERE",CRM[Description]))