new column to exclude rows containing or equal value

[Laeti]

Hello,

I have 3 columns with different information and I would like to exclude some values and I am stuck as I have too many different arguments.

For exemple I would like to exclude:

- all rows for which column A starts with T000 or

- all rows for which column B = US or

- all rows for which column C contains "tube"

Many thaks for your support!

[az38]

Hi @Laeti 

whats your desired result?

you can try a column like

Column =
IF(
RIGHT([column A], 4) = "T000" || [column B] = "US" || [column C] = "tube",
FALSE(),
TRUE()
)

then filter out in visual rows with Column = FALSE

[Laeti]

Thanks.

It works perfectly well for the first 2 columns but the column C is not = but it is contains tube. How can I mnage that third one? Thanks

[az38]

@Laeti 

try SEARCH()

Column =
IF(
RIGHT([column A], 4) = "T000" || [column B] = "US" || SEARCH("tube",[column C]) > 0,
FALSE(),
TRUE()
)