Hi Patty

You can use Advancedfilter to do this or use EasyFilter that have 5 options.
Another way is to use a helper column with a formula that will display "Yes"
when all 3 criteria are OK.

http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Patty via OfficeKB.com" wrote in message ...
How do I autofilter a list using 3 criteria? The default option is only 2.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1