| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to use auto filter to select more than 2 criteria?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to use auto filter to select more than 2 criteria?
thanks for your suggestion! -- 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Filter not showing all data | Excel Worksheet Functions | |||
| URGENT !! Auto Filter | Excel Discussion (Misc queries) | |||
| Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
| Averaging Values in Auto Filter | Excel Worksheet Functions | |||
| Auto Filter not working properly | Excel Discussion (Misc queries) | |||
Linear Mode
