Thread
:
Is it possible to use auto filter to select more than 2 criteria?
View Single Post
#
1
Posted to microsoft.public.excel.misc
Nick Hodge
external usenet poster
Posts: 1,173
Is it possible to use auto filter to select more than 2 criteria?
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 (DataFilterAdvanced Filter...)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS
"hello_lpc" wrote
in message ...
Hi,
It seems that in the customise function,it can only handle 2 criteria
only..Any suggestion?
Thanks
George
--
hello_lpc
------------------------------------------------------------------------
hello_lpc's Profile:
http://www.excelforum.com/member.php...o&userid=31304
View this thread:
http://www.excelforum.com/showthread...hreadid=560561
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge