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

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'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()
)