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

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.