View original (French)

Filter multiple columns at the same time

Solved
Phatted -  
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

  • Votes
  • Date
  • Descending date
  1. Raymond PENTIER Contributor
    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)