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 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!

3 Replies

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