Thread: Filter function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
venram
 
Posts: n/a
Default Filter function


A B
1 product Features in
2 Slide Room cover, portable
3 Sling Room cover, mobile, portable
4 Strap portable
5 Rail mobile

SELECT A & B
ACTIVATE AUTOFILTER
DATAFILTERAUOTFILTER
PRESS ARROWHEAD ON COLUMN B
DROPDOWN LIST WILL APPEAR
SELECT CUSTOM
SELECT "CONTAINS"
TYPE "PORTABLE" IN OPPOSITE FIELD
PRESS OK
this should solve the problem
thanks


--
venram
------------------------------------------------------------------------
venram's Profile: http://www.excelforum.com/member.php...o&userid=33813
View this thread: http://www.excelforum.com/showthread...hreadid=535865