Forum Discussion

Laeti's avatar
Laeti
Frequent Visitor
6 years ago

new column to exclude rows containing or equal value

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...
Laeti's avatar
Laeti
Frequent Visitor
6 years ago

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's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Laeti 

try SEARCH()

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