Filtering Multiple colums

[Belfast_stu]

Hi everyone, I am trying to filter all instances where a certian criteria is meet, is it possible to filter more than one colum at the same time? I have attached a sample sheet of my workbook but basically I am trying to return all rows that contain manufacturer 2.

Is filtering the correct way to go about this or am I looking at this all wrong?

Thanks in advance


Stu

[martindwilson]

in u3 dragged down
=COUNTIF(A3:T3,"manufacturer 2")>0
then filter on true
but in your example all the rows have at least on occurance of "manufacturer 2" anyway