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

[hello_lpc]

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

Thanks

George

[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]HIS


"hello_lpc" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[hello_lpc]

thanks for your suggestion!