Forum Discussion

htittoto's avatar
htittoto
Copper Contributor
Feb 07, 2020
Solved

Filter formula containing a text

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...
excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 07, 2020

    htittoto 

    Instead of

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

    use

    ISNUMBER(SEARCH("JOHN DEERE",CRM[Description]))
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 07, 2020

htittoto 

Instead of

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

use

ISNUMBER(SEARCH("JOHN DEERE",CRM[Description]))
  • htittoto's avatar
    htittoto
    Copper Contributor
    Feb 13, 2020

    SergeiBaklanThank you for your help, it Works perfectly!

Resources