Hello guys,
i have a following example table:
Column A, Column B, Column C
London, X14, 0
Paris, C84, -1
Brüssel, K99,0
New York, E12, -1
Now i want that the table only show the columns where the Value in Column C has a -1.
Column A, Column B, Column C
Paris, C84, -1
New York, E12, -1
I tried the following formular under the column "Column A" ind the "Show column if section":
=Sum(Column C)<0 also
=Sum(NUM(Column C))
Unfortunately it didn´t work.
Thank you in advance!
