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


Hi Brian,

If you are using Data - Filter - Autofilter, then click on the arrow at
the right of your filtering column you'll see some options at the top &
then your list of values.
Click on the option "(Custom...)", you will get a popup dialog box and
in the top left section it should say "equals" & have a dropdown arrow
immediately to the right. Click on the arrow, scroll down, select
"contains", tab into the right field & type "portable", and click ok.

Have a play, as you can see there are a number of ways of filtering
when using the custom option.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


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