Using advanced filter to search for criteria in a list

[Potatosalad2]

6/6/2005 12:30 DBAB Media VIA.B
6/6/2005 14:00 DBAB Media SFA YBTVA
6/6/2005 14:30 DBAB Media CMCSA CMCSK HHS
6/6/2005 15:00 DBAB Media ADVO PIXR SGA
6/6/2005 15:30 DBAB Media VCI WON

I am trying to use advanced filter to search for a specific group of
stocks (eg. I1:I100) in columns D-F and return only the stocks on my
list. eg. PIXR is on my list so the filter would return:

6/6/2005 15:00 DBAB Media PIXR

I am having problems getting the criterion correct. Can this be done
with advanced filter or is there an easier way?

 

[Debra Dalgleish]

You can use an Advanced Filter to return any row that contains PIXR, but
not just the column that contains PIXR. So, the result of your filter
would be:

6/6/2005 15:00 DBAB Media ADVO PIXR SGA

In the criteria area, leave the heading cell empty.
In the cell below, enter a formula that will check the stock columns, e.g:

=COUNTIF(E2:G2,$N$2)>0

where cell N2 contains the stock that you want to find.