View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default 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