Advanced Advanced Filter Criteria
Posted by Melanie Swarner on October 19, 2001 6:02 AM
I'm trying to use an advanced filter to filter out records. The problem is, I have a lot of columns and a lot of different combinations of criteria. I have a row with tolerance levels. I want it to look at the database and decide if the *absolute value* of the cell is greater than the tolerance. I know I can do this by making 2 rows one that says >Tolerance and another that says <-Tolerance, but there's more. Of the records that are outside of tolerance levels, I want to keep only the ones where another cell's *absolute value* is > than X.
Is there a way to put a formula as criteria. For instance, can I say If abs(DatabaseCell) > Tolerance Keep? I'm willing to use VB if it won't work with Advanced Filter, but I wouldn't know where to begin.
Thanks for any help!