A bit of an ugly solution but you could always create a new column that is
exactly the same as the column you want to filter on. Then you can choose one
of the criteria on the one column and the 2 other criteria on the original
column. Not pretty but it should be effective. If you are not sure about
using the autofilter you can see how to use it on
http://www.auditexcel.co.za/dataclean.html .

"Patty via OfficeKB.com" wrote:

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