Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On 24 Jun 2014 13:33:58 GMT, Isis wrote:
I want to show data rows based on 2 conditions using OR not AND. I want to show a row if it has a value in Field 14 OR If it has no value in Field 12 AND a value in Field 16 I have some code that filters on one Field but I am having trouble making the OR working. Any way to do that ? Any help appreciated. Thanks I don't think you can do that with AutoFilter. I think you have to use Advanced Filter. This will require setting up a criteria range on a worksheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |