Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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? -- Potatosalad2 ------------------------------------------------------------------------ Potatosalad2's Profile: http://www.excelforum.com/member.php...o&userid=20834 View this thread: http://www.excelforum.com/showthread...hreadid=377137 |
#2
![]() |
|||
|
|||
![]()
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. Potatosalad2 wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can Excel advanced filter be used in "and NOT" mode | Excel Worksheet Functions | |||
Advanced Filter Problems | Excel Discussion (Misc queries) | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |