How can I use Excel Advanced Filter to do the following formula:
=IF(OR(J21>1000,J21<-1000,K21>1000,K21<-1000),1,"")
So I want it to filter if either column J or K has a value below -1000 or above 1000. I have tried the following but it doesn't work completely:
Variance1 Variance2
>1000 >1000
<-1000 <-1000
Bookmarks