Jun 20 2017 12:23 PM
I am looking to create a filter such as the following ( (ColA<>"X" or COLB<>"X" or COLC <>"X") AND (COLD<>"Y"orCOLE<>"Y")). Is this possible? The individual OR blocks are easy enough but how to create that AND link is beyond my knowledge.
Jun 20 2017 01:55 PM
Hi Timothy,
That could be like
=OR($A1<>"X",$B1<>"X",$C1<>"X")*OR($D1<>"Y",$E1<>"Y")
Jun 21 2017 09:11 AM
You may also try this:
=AND(OR(A$1<>"X",B$1<>"X",$C1<>"X"),OR($D1<>"Y",$E1<>"Y"))