View original (French)

Filter multiple columns at the same time

Solved
Phatted Posted messages 64 Status Member -  
Phatted Posted messages 64 Status Member -
Hello,

I have 3 columns (A, B, and C) with a list of words, and I want to filter these 3 columns to display only the rows that contain the word "example" in one of these 3 columns.

Thank you

3 answers

  1.
    Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    In D2, you enter the formula =A2&B2&C2 that you copy downwards, and then you filter based on D.

    --
    Retirement is great! Especially in the Antilles...
    Raymond (INSA, AFPA)
    1