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

Not exactly what i was looking for, but it will do...
(I was hoping, that in the drop down menu, could choose "portable", and then
it would choose every row with portable).. but this can be used..

Thank you very much for the assistance.



"broro183" skrev:


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