Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Filter Function with "Not Contains"

Hi All, Any help would be appreciated I already have a formula in place , I just want to add third condition to this: First Condition : - if status =1 Second Condition : - Total time for same A v...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks ToddChitt I tried this one already but I want the condition which says for any C values of Same "A" column value that does not contain "ACL" or "BCL"

 

so here I should probably use Allexcept but that's not working. 

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
1 year ago

Sorry, I don't quite understand the comparison logic. Can you explain in plain language the relationship between A and C and what would, or would NOT, make a row acceptable or unacceptable.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    So A here is ID - 

    for same 1002 we have different C column Values, the idea here is if any of the C column for same value of A column has ACL or BCL it should not be in the result.

    • ToddChitt's avatar
      ToddChitt
      Icon for Super User rankSuper User
      1 year ago

      So if I understand correctly, all rows where colum A = 1001, NONE of column C values contain "ACL" or "BCL". Therefore, all of A= 1001 is included. But for A = 1002, there is at least ONE value in C that contains "ACL". Therefore, all of rows where A = 1002 are excluded.

      Did I state that correctly?

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Yes you are correct.
        Apologies if I couldn't explain better before.