Is it possible to use auto filter to select more than 2 criteria?

H

hello_lpc

Hi,
It seems that in the customise function,it can only handle 2 criteria
only..Any suggestion?

Thanks

George
 
N

Nick Hodge

Two criteria is all that is possible per column, but you could either
copy/paste the column to another spare column and use these two columns to
filter on or work with advanced filter (Data>Filter>Advanced Filter...)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
Top